As an IBM consultant for Cognos BI, my project experience is mostly related to the Cognos BI server, as well as TM1 within the Cognos family. However recently, I've been engaged with several shops running IBM Cognos Data Manager on Unix/Linux platforms such as AIX and Solaris SPARC looking for connectivity to SQL Server. I have also consulted on a couple projects running Cognos PowerHouse 4GL applications that required similar connectivity to SQL Server. And with the release of IBM Cognos BI 10.2, life in the Cognos world remains new and exciting for me.
Hopefully, every Cognos shop has seen my tutorial on connecting Cognos and SQL Server from Unix/Linux; and now I want to share what I learned working on a recent project where we engaged IBM support to configure the IBM Cognos Data Manager to integrate SQL Server data.
IBM Cognos Data Manager (formerly DecisionStream) is an ETL tool bundled with the Cognos BI and performance management solutions (including Rational Insight) to create data warehouses and data repositories for which operational SQL Server databases are a common source from Unix/Linux application servers. The Progress DataDirect Connect for ODBC SQL Server driver is recommended by IBM. And with the 7.0 ODBC release, we support the latest versions of SQL Server including 2012; and include native support for Windows Authentication from Unix/Linux against SQL Server without any external dependencies.
1. Download and install 32-bit DataDirect Connect for ODBC SQL Server driver for Unix/Linux.
2. Setup the Unix/Linux environment using the driver's odbc.sh or odbc.csh script in the install directory. In addition, configure the following environment variable:
setenv UDA_SS_DRIVER_MANAGER_LIBRARY libodbc.so:libodbcinst.so
2. Create an IBM Cognos Data Source Connection for Data Manager 10
Note: On the Connection Details tab, make sure to select "ODBC" and DBMS Type "SQL Server".
3. Test the connection using the sqlterm command line, for example:
connect ODBC 'UID=myUser;PWD=myPassword;DSN=mySQLServerODBC;DBMS=SQL Server;COGNOSSQL=FALSE'
4. Create and run a jobstream to access the SQL Server connection.
Call 1-800-876-3101 to speak with a live Solutions Consultant to learn how other organizations are using DataDirect SQL Server ODBC Driver to connect to SQL Server from IBM Cognos Solutions on Unix/Linux.
Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
You have the right to request deletion of your Personal Information at any time.
You can also ask us not to pass your Personal Information to third parties here: Do Not Sell My Info
Copyright © 2020 Progress Software Corporation and/or its subsidiaries or affiliates.All Rights Reserved.
Progress, Telerik, Ipswitch, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.