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.

SSRS using Impala as Datasource

SSRS using Impala as Datasource

New Contributor

Hello Folks, 

 

I am new to this community, trying to figure out how to do reporting using SSRS with Impala as data source.

 

Can you please guide me if there are any documentation or links?

 

1) Can we create stored procedures or only SQL statements?

 

Any inputs are appreciated. 

 

Thanks

1 REPLY 1
Highlighted

Re: SSRS using Impala as Datasource

Contributor

@BI123 

 

Please correct me if my understanding is right. So, SSRS (SQL Server Reporting Services) is a third party application for business intelligence and you want to use Impala as the service to pull data.

 

My guess is you have setup ODBC driver connection for Impala (assuming your application supports ODBC) on your host and ensure SSRS to use the driver to work.

 

Use the below documentation to setup ODBC driver.

https://www.cloudera.com/downloads/connectors/impala/odbc/2-6-11.html

Don't have an account?
Coming from Hortonworks? Activate your account here