Restoring a connection in Data Virtualization that was removed from Platform connections

If a connection is removed from Platform connections and the credentials change, users might see errors when they query tables that were created for that data source.

Symptoms

Connections that are used in Data Virtualization store details such as credentials in Platform connections. If you delete the Platform connection that Data Virtualization uses to connect to a data source, Data Virtualization can't look up credentials for the connection. Data Virtualization renders that connection unusable.

Resolving the problem

  1. On the navigation menu, click Data > Data virtualization.

    The service menu opens to the Data sources page by default.

  2. On the Data sources page, expand the connection to see the connection identifier (CID).

  3. In the overflow menu, click Edit connection. A dialog box with an option to use SQL to restore the connection opens. Select that option.

    To get details about the previous Platform connection, run the following query.
    select cid, cast(key as varchar(100)), cast(value as varchar(100)) from dvsys.connection_details where cid='<CID>'

    Where <CID> is the identifier from step 2.

  4. Use the setrdbcx stored procedure to restore the connection. For example, you can use the following command.

    DVSYS.setRdbcX('MySQLComm','192.168.0.1','3306','mydbname','','root','rootpassword','0','0','','','qpendpoint_4:6418','EDITCID=MYSQL10002',?,?,?)

  5. If you re-created the Platform connection and you want to link the Data Virtualization connection to it, you can specify a CCID (Platform connection identifier) option. For example, you can use the following command.

    DVSYS.setRdbcX('MySQLComm','192.168.0.1','3306','mydbname','','root','rootpassword','0','0','','','qpendpoint_4:6418','EDITCID=MYSQL10002,CCID=af1c20ef-b2f9-40c1-a548-8e81ee485c31',?,?,?)