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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Ian_dw Thanks for posting your question in Microsoft Fabric Community

You should be able to connect with MFA too, I would recommend installing the latest version of SSMS, when you say third-party reporting can you mention which one you are referring to?

Once you select the MFA authentication, there should be a popup that sends the notification to your phone

 

 

 

Regards

Geetha