ABSTRACT (by Federico Levis ) Category: install
Install and configure Squirrel SQL Client DB Client GUI.
Configure Squirrel to connect to the native IBM Cognos Content DB (Apache Derby DB):
1 Install and configure Squirrel SQL Client
Squirrel SQL Client is a graphical SQL client usefull to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands.
Dowload it from the official site (e.g squirrel-sql-3.6-standard.jar)
Install as administrator squirrel-sql-3.6-standard.jar
NOTE for Windows8: to install it as administrator run Command Prompt as administrator
and then execute: java - jar squirrel-sql-3.6-standard.jar
In the Installation Setup Wizard select the Optional Plugin - Derby (ant other Plugin that you desire):
2. Configure Squirrel to connect to the native IBM Cognos Content Database (Apache Derby DB)
Launch Squirrel SQL Client
Menu Window - View Drivers
Double Click on Apache Derby Client:
Click Tab Extra Class Path
Click Add and Insert the Cognos Derby Path. e.g for 32bit:
c:\Program Files (x86)\ibm\cognos\c10\derby10.8.2.3\lib\derbyclient.jar
Then Click List Drivers and Select in Class name the proper Driver:
Click OK and you will see a Window witha Green Confirmation:
Menu Window - View Aliases
Click + to Add a New Alias amd Insert the Derby Cognos Database parameters (you have to use Port configured for Cognos, i ths case 50001 )
Name=Derby_Cognos (Insert whatever name)
URL=jdbc:derby://localhost:50001/cm
user=cognos
pwd=cognos
Click Test to verify the connection and then Click OK (twice)
That's all: you will see all the Cognos DerbyDB objects as displayed in the Fisrt image.
Usefull Links: