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

[Former Member]

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

[Former Member]

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