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
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 .
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.