The Oracle data source selects data from a database in an SQL server.
An Oracle data source has the following settings:
A standard connection string used to identify the Oracle server, the database and authentication.
Select a table
Databases in an Oracle server can contain multiple tables. You can access these tables directly by selecting Select a table as the query method, and selecting the table from the drop down list.
Join multiple tables
Using 'Join multiple tables' you can combine data from multiple tables in the same database. You need to select the appropriate tables from the drop down list.
For each selected table, you must specify the name of the table and the ID column.
The ID column is use to match rows in all tables.
Specify SQL statement
If you select Specify SQL statement as the query method you