Skip to main content
Microsoft Idea

Developer APIs

New

Allow retrieving the connection details

Vote (4) Share
Olivier Schmitt's profile image

Olivier Schmitt on 16 Jul 2016 01:38:32

Given any report, we would like an api to retrieve the data connection details.
For example, if the report contains a "Customer" table, it would return information like:
the schema name that the table belongs to (dbo)
the database instance name (SQLServer)
the database server name
the connection type (ODBC, JDBC, OLEDB...)
other relevant connection details (jdbc url, odbc dsn, driver name)

Knowing where the data is coming from is important, it allows greater confidence and trust in the data being visualized.