Share via

ODBC connection string for Exasol, SSAS Tabular 2016

Daria Golchenko 1 Reputation point
2020-11-27T15:15:34.03+00:00

Hello,
I'm trying to connect with SSAS Tabular 2016 to Exsasol through ODBC Connector.
I only get the error message that the provider was not registered.

Exasol ODBC drivers have already been installed.

I suspect that the connection string is not correct. I found an example on Exsasol docs. https://docs.exasol.com/connect_exasol/drivers/odbc/using_odbc.htm

DSN=exa_test;UID=sys;PWD=exasol;EXASCHEMA=MY_SCHEMA;
DRIVER={Exasol Driver};EXAHOST=192.168.6.11..14:8563;UID=sys;PWD=exasol

Is it possible the string is different for SSAS Tabular 2016?

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,263 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Daria Golchenko 1 Reputation point
    2020-11-28T12:47:14.497+00:00

    Hi,

    I have solved it :)

    The connection string schould be: PROVIDER=MSDASQL;DRIVER={EXASolution Driver};DATABASE=…;EXAHOST=host:id;UID=login;PWD=passwort;

    0 comments
  2. Lukas Yu -MSFT 5,821 Reputation points
    2020-11-30T01:46:00.247+00:00

    Hi @Anonymous ,
    I have converted your comment as answer, since it worked for the case, you could mark it as answer. This would benefit other user and the forum.
    Thanks.
    Lukas

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    What can I do if my transaction log is full?--- Hot issues November
    How to convert Profiler trace into a SQL Server table -- Hot issues November

    0 comments