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.