MS CRM reading external database

Hi guys,
If I have some transactional records sitting in an external database
(outside of the MS CRM database), how can I:

- create new fields in say, Opportunities, and have these fields read
dynamically from this external database?

- or alternatively, create a new table in the MS CRM database, have
these new fields in Opportunities referenced/read from this new table?
I can add new tables into the MS CRM database through Enterprise
Manager, but Deployment Manager doesn't seem to be able to detect this
new table.

Urgently need input on this. Appreciate any reply at all!

Thanks and cheers

John
Tue Dec 02 22:20:34 CST 2003

I do not think you can have fields in CRM access an external database or new
tables added into crm however...you could create a new page in crm which is
populated from your database using asp.net etc


"KC" <kc4775@msn.com> wrote in message
news:a83d56d4.0312021855.334991af@posting.google.com...
> Hi guys,
> If I have some transactional records sitting in an external database
> (outside of the MS CRM database), how can I:
>
> - create new fields in say, Opportunities, and have these fields read
> dynamically from this external database?
>
> - or alternatively, create a new table in the MS CRM database, have
> these new fields in Opportunities referenced/read from this new table?
> I can add new tables into the MS CRM database through Enterprise
> Manager, but Deployment Manager doesn't seem to be able to detect this
> new table.
>
> Urgently need input on this. Appreciate any reply at all!
>
> Thanks and cheers

Hon
Wed Dec 03 05:32:24 CST 2003

True - another alternative is to have something like Biztalk to read data
from the external database and populate the relevant CRM fields. Can be
done.


"John O'Donnell" <csharpconsulting@nospam-hotmail.com-nospam> wrote in
message news:udSVNTVuDHA.1876@TK2MSFTNGP09.phx.gbl...
> I do not think you can have fields in CRM access an external database or
new
> tables added into crm however...you could create a new page in crm which
is
> populated from your database using asp.net etc
>
>
> "KC" <kc4775@msn.com> wrote in message
> news:a83d56d4.0312021855.334991af@posting.google.com...
> > Hi guys,
> > If I have some transactional records sitting in an external database
> > (outside of the MS CRM database), how can I:
> >
> > - create new fields in say, Opportunities, and have these fields read
> > dynamically from this external database?
> >
> > - or alternatively, create a new table in the MS CRM database, have
> > these new fields in Opportunities referenced/read from this new table?
> > I can add new tables into the MS CRM database through Enterprise
> > Manager, but Deployment Manager doesn't seem to be able to detect this
> > new table.
> >
> > Urgently need input on this. Appreciate any reply at all!
> >
> > Thanks and cheers
>
>