Skip to Content
avatar image
Former Member

How to connect to an microsoft SQL Server and get data?

Hi!

In some weeks i get a new project. The task will be to download informations from an microsoft sql server. Actually this is realized with the buisness connector but this should be realized with XI2.0. Does anyone already did something like this and could give me some informations?

I think the best way is to call a stored procedure and to return a result set. But i have never seen XI so i want to get some informations bevor ich start the project. So i look for some informations about XI and a connection to an sql server. If anyone got these informations i would be pleased, if you could sent it to me.

Thanks a lot.

Bye

Grigor

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 21, 2004 at 05:44 PM

    XI provides a Database Adapter called JDBC Adapter. This Adapter is able to execute SQL commands and returning the according resultset to XI. Within XI you can transform the resultset to whatever message format you need and send it to a receiving system.

    As by now, i normally used direct table access or access to my own view within the database. However executing a stored procedure should also work, but the documentation states the restriction "... stored procedure that contains exactly one SELECT statement".

    Best Regards

    Christine

    Add comment
    10|10000 characters needed characters exceeded