My Profile
Sign Out
Tickets
Knowledge Base
Login
Articles in this section
Category / Section
  2. Data Sources

Extract Specific Oracle Table with Bold BI

Published:

The Oracle connector in Bold BI allows you to extract a specific table, reducing loading time on table selection and data source preparation.

To connect to a specific table, simply enter the desired table name in the Additional Connection Parameters text box when connecting to the Extract mode data source, as illustrated in the screenshot.

specifictable=table_name

image.png

By adhering to this procedure, only the specified table(s) will be retrieved and displayed in the Extract Data dialog box, as depicted in the screenshot.
image.png

Connecting multiple tables:

If you need to extract multiple tables, please use the following syntax in the Additional Connection Parameters input field:

    specifictable=table1,table2,table3

image.png

image.png

Additional References

Was this article useful?
Like
Dislike
Help us improve this page
Please provide feedback or comments
GR
Written by Gayathri Ravichandran
Updated:
Comments (0)
Please  to leave a comment
Access denied
Access denied