3rd Party Tool Connectivity

[Ian_dw]

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 have to use Multi Factor Authentication MFA to login in.

What do I need to do so I can just use a Username/Password combination either using OLE DB or ODBC??

Thanks Ian

[Ian_dw · Accepted solution]

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;UID=User@X.com;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 id=zzzz@x.com; 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]

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)

[GeethaT-MSFT]

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