Hi All,

I am stucked in a problem and didn't found any way to come out of this.

I am working on LN FP9. From there i want to fetch few records from another server(Baan V). Is this possible?? I mean can i fetch records from BaanV through LN code and both are different servers.

Any help will be appreciated:)

Thanks

Hi,

Yes, its possible using many ways. One way is to create a bat file which will call a 3gl program in Baan 5 which will generate a file with the records from the required table.

Now, call that bat file from your LN code. Once the file is generated, read the file and import the data.

Else there are different possible ways using shells, database connections etc. Depends on how frequently are you going to use it and how much time you want to spend on building the tool.

Also check this Thread! (http://www.baanboard.com/baanboard/showthread.php?t=42323)

Hi Bhushan,

Yes file creation is a way and i don't want to use that will take time.

I have no idea how to connect with shell or database by script. It seems a great idea. Can you share if you have done like this before.?


Thanks

Hi,

That depends on which databases you are using at both ends. In past, I have used Stored Procedures & SSIS to connect tables between 2 databases on different servers. Both my databases were SQL Server 2008 R2.

It will require a lot of troubleshooting if you are new to it as well as you have to take care of the data consistency. The other way would be a better option as its more "Baan Way" and a safer one too.