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.
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.