Connecting to a database
Establish connection to a database.
To connect to a database:
- Enter the session name.
- To complete the connection string, click Browse to show the Data Link Properties window.
- Select the database provider and enter the full path of the data source.
- To ensure the database connection is working, click Test Connection.
- To enhance security, press the F2 key to insert a Credential Variable.
- Click Save.
When connecting to an Oracle database if you encounter an error in initializing the provider, it might be a required driver for your Oracle database is not properly installed. Reinstalling driver resolves the issue. For information about how to resolve this issue, see this article: Getting Error of Initializing Provider while Connecting to Oracle Database (A-People login required)