Connect to external SQL Server from Application server running on OS400

[manoj2910]

Hi,

I have a situation where I need to connect to an external SQL server form SAP Application Server running on OS 400. I will be giving connection details at DBCO. Can and one suggest me how to configure ODBC and where do I find .so files for the connection.

Thanks in Advance

Manoj

[christoph_ostrop · Accepted solution]

Hi, Manoj,

(for DB-connect) please look at sapnote:

https://launchpad.support.sap.com/#/notes/523381

https://launchpad.support.sap.com/#/notes/146624

https://wiki.scn.sap.com/wiki/display/BI/Common+issues+related+to+DB+Connect

but as i remember, for a MSSQL-DB there is no ODBC-Driver (for IBM-i) ?

so we did it using UD-connect (with JDBC-Driver to MSSQL)

to load data from MSSQL into SAP-Netweaver-BW 7.31 running on IBM-i

https://launchpad.support.sap.com/#/notes/1658310

https://scn.sap.com/thread/1960808

https://wiki.scn.sap.com/wiki/display/SAPSQL/Remote+MS+SQL+Server+database+connections

https://wiki.scn.sap.com/wiki/display/BI/Configure+UD+Connect+in+NWA+for+7.3

https://help.sap.com/saphelp_nw73/helpdata/en/a6/c0e51914e842e19bda39dbbe4fe78c/content.htm

https://scn.sap.com/thread/3480129

HTH

Christoph

[manoj2910 · Accepted solution]

Hi Chisrtoph,

Thanks for the links, I shall go through and come up with a solution ASAP.

meanwhile I also found this link which gave me an insight regarding this and which might help others - https://www.scottklement.com/presentations/External%20Databases%20from%20RPG.pdf

Regards,

Manoj

[manoj2910 · Accepted solution]

Hi Christoph,

I cannot use UD-Connect since we don't have J2EE Server. We only have ABAP server as of now.

[volker_gldenpfennig · Accepted solution]

Hi Manoj,

ok, but it is pretty simple:

If you want to connect to MS SQL Server from System i, you do need either a J2EE Engine via UD-connect or a windows appl server via DB-Connect - nothing else will work ...

A windows appl server can always be installed additionally and does not need much horse power.

Regards,

Volker Gueldenpfennig, consolut international ag

[manoj2910]

Hi Volker,

Thanks for the suggestion. will consider that.

I would also like to try connection DB2 from SQL Server 2014. instead for trying to connect SQL Server from OS 400.

Regards,

Manoj