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

Hi Geetha, I had already connected via SSMS, which is as you say via Auth with MFA. I also have an account with the MFA turned off, but I still have to use Auth with MFA in the SSMS connection string!! 

I have  3rd party tool called BoldReports which the client uses and various connectors to talk to databases, ie JSON, REST,  OLE, ODBC and so on, which most have a Username/Password combo, but still can't connect with my account which doesn't have the MFA turned on?? Previuosly for dumb reports a simple user account with a password has worked for other applications, is there something like a firewall / office gateway etc getting in the way?? (BoldReports can convert SSRS reports into it's pwn format)