on 01-23-2012 12:34 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.