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

Niraj Kesarwani 0 Reputation points
2024-04-16T17:29:33.8566667+00:00

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.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,802 questions
Microsoft Managed Desktop
Microsoft Managed Desktop
A cloud-based service that brings together Microsoft 365 Enterprise and adds these features: User device deployment; IT service management and operations; and Security monitoring and response.
44 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,126 Reputation points
    2024-04-17T02:14:48.6966667+00:00

    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.

  2. ZoeHui-MSFT 33,126 Reputation points
    2024-04-18T01:56:28.4066667+00:00

    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.

    0 comments