Sharing database connection information through a repository database

You can share database connection information through a shared repository database in Data Studio web console or InfoSphere® Optim™ Configuration Manager.

If you have an instance of Data Studio web console or InfoSphere Optim Configuration Manager installed and configured to share database connection information, you can configure the Data Studio client to import the database connection information into connection profiles in your workspace. To import the database connection information, you open the Import Connection Profiles wizard in the Data Studio client by clicking Import Import button in the Administration Explorer or the Data Source Explorer.

See the following sections for details on how to share database connection information between the Data Studio client and Data Studio web console or InfoSphere Optim Configuration Manager:

Data Studio web console
You can import the connection profile information from the Data Studio web console into the Data Studio client and also add your connection profile information from your workspace in the Data Studio client to the repository database of the web console. You must set up a repository database in the Data Studio web console and configure the web console for multi-user mode to share database connections, see Configuring for multi-user mode for details. To import and add database connection information to the Data Studio web console, see the following sections:
Importing connection information into the Data Studio client
To import the database connections from the repository database of the Data Studio web console, you specify the URL in the Import Connection Profiles wizard of the Data Studio client. To keep your Data Studio client synchronized with the Data Studio web console, you must manually open and run the Import Connection Profiles wizard.
Adding connection information to the Data Studio web console
You can add database connections to the web console with the following methods:
  • The administrator of the Data Studio web console can add database connection information through the Databases page in the web console, see Adding or importing database connections for information about adding database connections in the web console.
  • To add database connection information to the repository database of the Data Studio web console, see Automatically adding database connections to the web console for information about sharing the database connection information from your Data Studio client with the Data Studio web console.

For more information about sharing database connection information between the Data Studio client and web console, see Scenario: Sharing Data Studio client database connection profiles by using the web console.

InfoSphere Optim Configuration Manager
You can import connection profile information from the InfoSphere Optim Configuration Manager Server into the Data Studio client and also add your connection profile information to the repository database of the InfoSphere Optim Configuration Manager Server. To import and add database connection information to the InfoSphere Optim Configuration Manager Server, see the following sections:
Importing connection information into the Data Studio client
You specify the URL to the InfoSphere Optim Configuration Manager Server in the Import Connection Profiles wizard of the Data Studio client to import the shared database connections from the repository database. You can also edit the URL or specify the behavior of how connection profiles are synchronized with the InfoSphere Optim Configuration Manager Server in the Preference page at Windows > Preferences > Data Management > InfoSphere Optim Configuration Manager.

You specify which connection profiles to import with the Import Connection Profiles wizard in the Data Studio client. By default, after every 60 minutes or when you restart your workspace, the properties of all imported connection profiles are automatically updated with changes from the InfoSphere Optim Configuration Manager Server. Only the connection profiles that you initially import are automatically updated. To import other connection profiles that exist on the InfoSphere Optim Configuration Manager Server, open and run the Import Connection Profiles wizard. You can also manually synchronize with the InfoSphere Optim Configuration Manager Server by clicking Refresh in the Administration Explorer or right-clicking the connection profile in the Data Source Explorer and selecting Refresh.

When you synchronize with the InfoSphere Optim Configuration Manager Server, the results are displayed in the Problems view of the Data Studio client.

Adding connection information to the InfoSphere Optim Configuration Manager Server
Only users who have access to the InfoSphere Optim Configuration Manager Server can add database connection information through the Databases page in InfoSphere Optim Configuration Manager, see Adding and importing database connections.

For more information about InfoSphere Optim Configuration Manager, see in the InfoSphere Optim Configuration Manager Information Center.

The database connection information that you import is listed in the All Databases folder in the Administration Explorer or the Database Connections folder in the Data Source Explorer.

Database connections that you import from repository databases overwrite only the database connection information that you previously imported. Database connection information in connection profiles that you manually create on your workspace are not overwritten or updated by the database connections you import.


Feedback