cancel
Showing results for 
Search instead for 
Did you mean: 

SAP on IBM i and connectivity to MSSQL.

Former Member
0 Kudos

Hi,

Our BI system, which is running on IBM i, must extract data from a remote SQL Server Database. Is there any 'standard' way to connect ? Is there any option for a *DRDA connection ? Any idea ?

Regards,

Joan

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
0 Kudos

The only way to do this is to install a Windows application server and install the database client for SQL-Server - and then use DBCO to connect.

Markus

Answers (1)

Answers (1)

Former Member
0 Kudos

Joan,

We use a separate software package called RDB that can connect to a MSSQL database. We use it to connect to MySQL but it supports MSSQL too. We use it with RPG and it also works with COBOL. You might want to contact them to see what they can do to connect to SAP. The company and support are excellent. The url is:

http://www.prodatacomputer.com/rdbConnect.shtml

Alan