Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.