Forum Discussion

Ian_dw's avatar
Ian_dw
Regular Visitor
3 years ago
Solved

3rd Party Tool Connectivity

  Can anyone suggest how I can connect a 3rd Party Reporting suite (Bold Reports) to a Warehouse in Fabric??   I can connect SQL Server Management Studio to the SQL Endpoint provided, but it I hav...
admin
  • Ian_dw's avatar
    Ian_dw
    3 years ago

    In my version of Bold Reports, I managed to get ODBC to work, after out IT Dept, recreated the account from scratch, with MFA turned off.

     

    The critical aspect with ODBC was to include the Driver name and get the latest release !!

    driver={ODBC Driver 18 for SQL Server};server=zzzzzzzzzzzzzzz-ufyu7j4a4veulic7sb46gzfiai.datawarehouse.pbidedicated.windows.net;database=zzz_db;[email protected];PWD=C123;Authentication=ActiveDirectoryPassword;Encrypt=yes

    However, I have been told ODBC is not available on our production systems, and not supported, so the Bold Reports support team, has kindly written a new connector where the connection string to use is :-

    Server=zzzzzzzzzzzzzzzzz-ufyu7j4a4veulic7sb46gzfiai.datawarehouse.pbidedicated.windows.net; Authentication=Active Directory Password;

    Database=zzz_db; Trust Server Certificate=true; user [email protected]; PWD=C1234


    I suspect our new written driver will become part of future BoldReport releases?? If not their Support has the answer!!

    Ian

Ian_dw's avatar
Ian_dw
Regular Visitor
3 years ago

In my version of Bold Reports, I managed to get ODBC to work, after out IT Dept, recreated the account from scratch, with MFA turned off.

 

The critical aspect with ODBC was to include the Driver name and get the latest release !!

driver={ODBC Driver 18 for SQL Server};server=zzzzzzzzzzzzzzz-ufyu7j4a4veulic7sb46gzfiai.datawarehouse.pbidedicated.windows.net;database=zzz_db;[email protected];PWD=C123;Authentication=ActiveDirectoryPassword;Encrypt=yes

However, I have been told ODBC is not available on our production systems, and not supported, so the Bold Reports support team, has kindly written a new connector where the connection string to use is :-

Server=zzzzzzzzzzzzzzzzz-ufyu7j4a4veulic7sb46gzfiai.datawarehouse.pbidedicated.windows.net; Authentication=Active Directory Password;

Database=zzz_db; Trust Server Certificate=true; user [email protected]; PWD=C1234


I suspect our new written driver will become part of future BoldReport releases?? If not their Support has the answer!!

Ian