IBM Cognos Data Manager ODBC connectivity to SQL Server from Unix/Linux

IBM Cognos Data Manager ODBC connectivity to SQL Server from Unix/Linux

November 28, 2012 0 Comments

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.

What is IBM Cognos Data Manager?

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.

Getting Started:

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.

 

Interested in learning more about IBM Cognos to SQL Server from Unix/Linux?

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.

Sumit Sakar

Sumit Sarkar

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.

Comments
Comments are disabled in preview mode.
Topics
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

More From Progress
2020 Progress Data Connectivity Report
2020 Progress Data Connectivity Report
Read More
 
232x131_resourceimage
Getting Ahead of the Hybrid Data Curve
Read More
 
autonomousrest
Creating Quick, Codeless Connectivity with Autonomous REST Connector
Read More