PowerCenter Express ETL Tool

This post is a follow-up from the other post on the Talend ETL tool. The current version of the PowerCenter Express tool provides support to a limited number of database platforms only (e.g. no MySQL of all kinds yet – Community, Enterprise, Amazon Aurora, etc.). However, it is sufficient enough to handle your simple data […]

Configure SQL Server Connection in Cognos 10.2

You have tried Oracle, MySQL so far in Cognos 10.2. Let’s configure another popular data source for Cognos. When your environment uses the default instance name MSSQLSERVER Copy the appropriate Oracle jdbc driver to the Cognos directories outlined in this post IBM Cognos 10.2 evaluation Launch your Cognos Administration via this URL http://localhost:19300/p2pd/servlet/dispatch (replace localhost […]

JDBC Drivers

You can download some of the jdbc drivers mentioned in my posts on this site. Oracle 11g ojdbc5.jar ojdbc6.jar Oracle 12g ojdbc6.jar ojdbc7.jar MySQL mysql-connector-java-5.1.38-bin.jar SQL Server sqljdbc4.jar sqljdbc41.jarsqljdbc42.jar jtds jtds-1.3.1.jar Below are the links that you might want to go directly for any latest updates http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html https://dev.mysql.com/downloads/connector/ https://www.microsoft.com/en-us/download/details.aspx?id=11774 http://jtds.sourceforge.net/