Supported Server Versions: Oracle Database (11g, 12c, 18c, and 19c)
Oracle connection type, you can connect an Oracle database.
DATA configuration panel, click on the
NEW DATA button.
Oracle data source type.
After clicking the data source, the
NEW DATASOURCE configuration panel opens. Follow the below steps to create oracle data source:
Specify the data source name without special characters, in Name field.
Then enter the valid connection string as mentioned below and authentication type to connect with specified data source.
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword;
Click on the
Connect to proceed with query design pane. Now, enter the required query and execute. Its corresponding values will be shown in grid for preview.
Only query mode is supported for oracle data source.
Finish to save the data source with a relevant name to proceed with designing report.
You can set oracle database credentials, prompted credentials, or use no credentials.
Authentication - A user name and password must be supplied to access the oracle database, the credentials might be for a database login. The credentials are passed to the data source for authentication.
Enable the Save password option to embed the credentials within the report when saving it in Report Server.
On report download action, the credentials will be not be saved with report data.
Prompt - When you configure a data source connection to use prompted credentials, each user who access the report must enter a user name and password on preview action to retrieve the data.
None - Choose the authentication type as
None, when the authentication details or any other arguments required to connect with the data source are provided in connection string.