|
Hi Steeve, Thanks for the response. I was also able to achieve the same result
using, as you have mentioned, ODBCConnection. I just had to set the server / username
/ password and voila, I was in!!! J Regards. From: I've tested similar
scenario on our Dev server. I use MS SQL as my DB. In the
Enterprise Manager, go to "Security" folder of your Axapta DB server
and in the "Linked Servers" nodes add your Scala server. With
the use of ODBCConnection or UserConnection you can now do : "select * from
scaladb.dbo.someTable" Hope it helps. Steeve... -----Message d'origine----- Hi All, I have a scenario where I need to
fetch data from different server / database and fetch a set of record from tables
and insert those records into the tables of Axapta database which is different
from the server / database where we are fetching data from. I have explained the scenario below
for more clarification There are 2 server 1.
Scala and its database is called ScalaDB 2.
Axapta and its database is called AXDB. I have connected AXDB database using
Axapta. Now my requirement is such that I need to connect for Scala server and
ScalaDB database and fetch data from respective table of that database and
insert the fetched data into AXDB database of Axapta server using X++. Taking
into consideration that there is a mapping being already done between tables
and fields of to different database. Regards, Jay.
Sharing the knowledge on Axapta. Yahoo! Groups Links
|
