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

Question

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.

Answer 1

Hi @Niraj Kesarwani,

As far as I known, report builder is a 32bit application.

Could you please try to install 32bit ODBC driver and test?

In addition, you may also try to use VS2022 to design the report which is 64bit.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hi @Niraj Kesarwani,

I misunderstand your issue yesterday, if you mean that you want to display the table list in ODBC source so that you can choose the table name for further use, it is temporarily unavailable now in report builder or VS.

You may raise your idea here, the product team will consider adding new feature if your opinion has been voted.

For Suggestions/Other Ideas: Tell us how this impacts your business operations and how what you're asking for will enable/unblock your scenario. Be as descriptive as possible!

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.