Is there a trick to getting the SQL Server BI tools to connect to HANA. I was trying to use SQL Server 2012 Reporting Services and SQL Server Data Tools to build reports to try and connect and I'm getting a consistent failure when setting up a data link to the ODBC driver. I'm using v38 of the client tooll x64 bit version.
I first setup a User (or System or File) DSN using the ODBC Data Source Administrator - no problems with connecting via the tool using Server:port imdbhdb:30015 for the port. Clicking Connect prompted me for Use and Password and connected without SSL and got a Connect sucessful! message.
When I go into SQL Server Data Tools or use the SQL Server 2012 Report Builder to create a Data Link - this is where the problems start. The example I'll walkthru here is creating a Tabular Data model for Analysis Services using SQL Server Data Tools.
This results in the very unexpected error:
Test connection failed because of an error in imitializing provider. [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.
Any help would be greatly appriciated.
Regards,
Bill