Microsoft SQL server and stored procedures

[Former Member]

Hi!

We sant to download informations from an microsoft sql server.

Does anyone already did something like this and could give me some informations?

I need to know if it's possible to call a stored procedure

I am evaluating possibilities and want to get some informations before 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 in advance.

A.D.

[Former Member]

hi

this you can do with JDBC driver

'You have to deploy the required JDBC drivers for the database before making connection. Ask the database provider or your vendor for the divers. That should be deployed using SDM tool

Start visual admin of XI and select service "Deploy" and then select option "Deploy and start" to select file and deploy it

now here is the steps to deploy this module.

How to deploy adapter module in production

Three option available:

1. Using SDM

2. Using Visual Admin

3. Using NW development studio (Not available for Production)

We will use Visual Admin u201CDeployu201D deploy service to deploy EAR file of adapter module.

Steps:

1. Goto VM->Deploy service

2. Select option u201CDeploy and startu201D

3. Select EAR file provided for deployment

4. Restart the service.

5. Done

follow this guide

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2df...

some good scenarios

- File to JDBC

Receiver JDBC scenario MS access -

regards

sandeep

[Former Member]

Hi ADS,

As above said it is possible to call the Stored procedure from XI.

For this you need to download the SQL Server drivers from microsoft and deploy in XI server.

And you need to provide the credentials like Connection details, driver name , username and password in the Communicaiton channel to connect SQL server from XI system at runtime.

Then you can proceed to develop the scenaio.

Regards

Goli sridhar

[dharamveer_gaur2]

Hi

It is possible to connect to database with the help of JDBC adapter.

you can Execute Stored Procedure from XI.

You can Fetch data using JDBC Sender Adapter and Insert,Update,Delete using JDBC receiver Adapter.

look use of Stored Procedures in JDBC:

[Former Member]

Hi AD

I need to know if it's possible to call a stored procedure 

Yes its possible using XI JDBC adapter.

Stored procedure can also be called using this.

Thanks

Gaurav

[Former Member]

Hi,

You can connect to SQL Sever through XI's JDBC Adapter. The connection details in communication channel are given below for SQL Server 2005

JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

Connection: jdbc:sqlserver://sqlserverIP:port;DatabaseName="yourdatabasename"

Required User name and password to connect to SQL Server

If you want to update multiple tables, then you can write a stored procedure in SQL Server and you can call it in the update statement of your JDBC communication channel.

You can call the stored procedure as EXEC [storedprocedurename]

Hope this is helpful

Do get back to me for any further details

Regards

Kiran.

[Former Member]

Yes you can connect to SQL server and you can also use JDBC adapter for your scenario.SP can also be able to called.

Thanks

Prabhakar

[MichalKrawczyk]

hi,

>I need to know if it's possible to call a stored procedure

yes it is - you can do it with XI's JDBC adapter

you can also pull data directly from tables

with jdbc sender adapter

Regards,

Michal Krawczyk

http://mypigenie.com - XI/PI FAQ