Connecting via IBM Cognos

Connecting IBM Cognos to bit.io

Cognos works well with bit.io, but does require some setup. We've put together this guide to help you get setup.

1) Setup The Data Server Connection

To connect to bit.io via IBM Cognos use the Postgres connector.

856856

Go to the menu in the upper left corner and select Manage and then select "Data server connections".

15621562

Click + and click PostgreSQL.

10521052

Change the name of the connection (Congnos requires you do this). Change the authentication method to Use the following signon

15281528

Go to bit.io and click on the connect button. Copy your username and password.

860860

Edit the connection credentials and put in your username and your password.

21722172

Click Edit next to connection details, and for the JDBC url put in jdbc:postgresql://db.bit.io/bitio. Finally, click Save and Test.

2) Load The Schema Metadata

10661066

In the same window, click Schemas

13561356

For any schema you are interested in, click the ... that appears when you hover over the schema name, and click Load metadata. This will populate the data module, and let you use the data in your reports. Once the metadata is loaded, you can close this window.

3) Use The Data!

598598

Let's create a data module. First, click on the upper left menu and click Content

20782078

Click New and Data Module

19421942

On the left hand side select Data server (the fifth option down), and click on the bit.io server we just created.

19701970

Click on the server, then click on the schema we loaded the metadata for, and click OK. Click Select Tables and pick the tables you want to work with. You're done!


Did this page help you?