Available in...Big Data Platform
Cloud API Services Platform
Cloud Big Data Platform
Cloud Data Fabric
Cloud Data Management Platform
Data Fabric
Data Management Platform
Data Services Platform
MDM Platform
Real-Time Big Data Platform
You can edit the connection to a specific database and change the connection
metadata and the connection information.
Before you begin
A database connection is created in the
Profiling
perspective.
Procedure
-
In the DQ Repository tree view, expand .
-
Double-click the database connection you want to open.
The
Database Connection wizard is displayed.
-
Go through the steps in the wizard and modify the database connection
settings as required.
-
Click Finish to validate the
modifications.
A dialog box opens prompting you to reload the updated database connection.
-
If you want to
reload the new database structure for the updated database
connection, select reload.
Note: If you select the don't reload option, you will still be
able to execute the analyses using the connection even after you update
it.
When the database connection is used by profiling analyses in the Studio, the
Exist client dependency dialog box is displayed to list all
the analyses that use the database connection. It alerts you that if you reload the
database new structure, all the analyses using the connection will become unusable
although they will be always listed in the DQ Repository tree
view.
-
Click OK to accept reloading the database
structure or Cancel to cancel the operation
and close the dialog box.
A number of confirmation messages are displayed one after the
other.
-
Click OK to close the messages and reload
the structure of the new connection.
The Database Connection wizard is displayed.