Can't display the list of the table through ODBC from Report Builder

[kesarwani09]

Can you please help or confirm with the information below as earliest

We are trying to connect TIBCO Data Virtualization from Report builder through ODBC connection and it allows to connect this data source through query designer in free form text which is very painful.

we are looking to list all the table available to that schema and fetch desired table based on the requirement and do not want to write a query as hard code. Query designer should allow flexibility to display all the tables like other connector which is already available in the report builder data source drop down list.

Is this Report builder's limitation if we try to connect any data source through ODBC connection and it will not allow us to display all the table or any work around to fix this issue?

Note: We have tested same ODBC driver with other client and locally while creating the DSN , It allows to fetch all the table when selecting data model tab in ODBC Data Sources (64 bit) configuration.

[v-xiandat-msft · Accepted solution]

Hi @kesarwani09 ,

 When using ODBC connections in Report Builder, the tool primarily expects queries to be provided in a free-form text manner. This is a limitation that stems from the generic nature of ODBC connections

You can use a generic SQL query to retrieve a list of tables from the schema. For example, a query like can be used to list all tables within a specific schema.

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'YourSchemaName''YourSchemaName'

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.