Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How can i fix the connection string in order to connect Impala & Cognos Analytics ?

How can i fix the connection string in order to connect Impala & Cognos Analytics ?

Contributor

I want to connect Cognos Analytics  11.1 with Cloudera Impala. 

The connection string that I have used  so far is : 

 

jdbc:impala://host:port/<schema name>. Also the jdbc that i used at cognos is Simba JDBC Driver for Impala.

 

My question is , I want to to see tables from different schemas. How is this possible, when I put the name of a certain schema into the connection string?

 

1 REPLY 1

Re: How can i fix the connection string in order to connect Impala & Cognos Analytics ?

Guru

Hi,

Firstly I would suggest using Cloudera Impala JDBC Driver, if it is not what you are using already:
https://www.cloudera.com/downloads/connectors/impala/jdbc/2-6-4.html

Secondly, the schema name is just used for initial connection, once you are connected, you can still have access to tables under other databases. In query edit, simply run "use {databasename}" to switch between schemas.

Hope it helps.

Cheers
Eric