cancel
Showing results for 
Search instead for 
Did you mean: 

Connecting to different DBMS using DB connect from BI on iSeries

Former Member
0 Kudos

Hi Gurus,

We have a requirement, where we need to connect to an external DBMS (MS SQL Server) running on Windows server from our BI 7.0 systems running on IBM iSeries with DB2.

Is it possible to connect to external MS SQL server from our BI system which is running on iSeries.

If so, how can i achieve this?

Can anyone provide me step by step process to configure this if it is feasible.

Let me know if you need additional details.

Regards,

Ram.

Accepted Solutions (0)

Answers (1)

Answers (1)

markus_doehr2
Active Contributor
0 Kudos

To connect to an external database you basically need two software components:

- the database interface library (lib_dbsl)

- a database client for the target database

Since neither of the above is available for i5/OS you will need to install an application server on Windows, install SNAC (the SQL database client there) and run the necessary programs on that server.

Markus

Former Member
0 Kudos

Hi Markus,

Thanks for your reply.

By saying neither of them available for i5 OS, do u mean, we cannot install Database dependent (MS SQL) DBSL and DB client in i5 OS?

Is there any other way, except installing new app server in windows as the latter is not possible in our environment right now.

Awaiting your reply.

Regards,

Ram.