Managing database connections with the IBM Data Studio web console

Learn how to use the web console of IBM® Data Studio to manage and share database connection information. This feature helps increase productivity among Data Studio users and reduce the overhead of tooling configuration.

Share:

Loic Julien (lj@us.ibm.com), Software Architect, IBM

Loic JulienLoic Julien is a senior software engineer at IBM and is currently working on the architecture and the development of all core components within IBM Data Studio. Loic has historically contributed to the development of InfoSphere Data Architect, Rational XDE, and Rational Rose. Loic has a master's degree from San Jose State University in client/server computing.



Kevin McBride (kmcbrid@us.ibm.com), User Experience Architect, Senior Technical Staff Member, IBM

Kevin McBrideKevin McBride is a senior technical staff member for IBM, focused on user experience in information management. He is the inventor of 18 patents in Internet, database, and user-interface technology. He has been a guest lecturer in User-Centered Design at University of California, Berkeley, School of Information Management Systems.



Quddus Chong (qchong@us.ibm.com), Optim Tools Information Developer, IBM

Quddus ChongQuddus Chong joined IBM in 2003 after an internship with IBM Extreme Blue. He worked with the Informix team in Lenexa for three years as an infrastructure software engineer. In 2006, he joined IBM Silicon Valley Lab to work as a software accessibility specialist, then as the lead programming writer for IMS application development. Currently, he is an information developer for InfoSphere Optim Query Tuner products and the IBM Data Studio web console.



10 November 2011

Also available in Chinese

Introduction

In today's enterprise organizations, data is managed across a complex ecosystem of heterogeneous data sources and data assets. One challenge faced by database administrators (DBAs) is to ensure that the requisite database connection information is securely and efficiently shared with authorized applications and users.

Feature deprecation

The new database connection sharing feature replaces the older common connection configuration solution detailed in "Using common connections with Optim solutions." The common connection configuration solution is being deprecated, starting with IBM Data Studio V3.1 and will be discontinued in a future Data Studio release.

IBM Data Studio (comprising the Data Studio full client, Data Studio administration client, and Data Studio web console) is a portfolio of tools for simplifying database development and administration. For an overview of the Data Studio clients and web console, see Getting started in IBM Data Studio.

This article outlines how IBM Data Studio offers a new solution that allows you to promote database connection sharing across your Data Studio user base. Starting with IBM Data Studio V3.1, you can use the Data Studio web console to store your connection information in a single repository to share among team members. Database connections are shared by all components and users of the web console.


Prerequisites

Data Studio web console

The Data Studio web console can be used to create and manage the lifecycle of any available Linux®, UNIX®, or Windows® or z/OS® database connections within the enterprise. Before you set up database connection sharing on Data Studio, you need to install and configure the Data Studio web console.

If you are planning to make the web console available to multiple users, you will also need to have an existing database to use as the repository database. Any connections you want to specify for sharing must be added after the repository database is defined. Connections created before the repository database is defined are lost.

For more information on installing the web console, see Installing and configuring Data Studio web console.

Data Studio Eclipse-based clients

The IBM Data Studio product line include two Eclipse-based clients:

IBM Data Studio Eclipse full client

Starting with V3.1 of IBM Data Studio full client, Optim™ Development Studio and Optim Database Administrator for DB2® for Linux, UNIX, and Windows have been folded into IBM Data Studio.

  • IBM Data Studio full client
  • IBM Data Studio admin client

The IBM Data Studio full client provides complete editing capability, well suited for developers or consumers of other compatible IBM products, such as IBM Rational® Software Architect or IBM Rational Application Developer.

The IBM Data Studio admin client, on the other hand, provides a lightweight environment, focused on data management, that non-Java™ developers tend to prefer. The full client and the admin client include two explorers to manage the lifecycle of their connections:

  • The new Administration Explorer (see Resources) is always being associated with a separate display view, called the object list view. Such a view represents the underlying data objects of each connected connection, along with their respective properties.
  • The Data Source Explorer displays a complete hierarchical structure for each connected connection.

As both explorers offer a different presentation layer, we will refer to the Administration Explorer moving forward, but keep in mind that this is interchangeable.


Managing connections within the enterprise

In today's enterprise systems that span development, production, testing, internal migration, and more, DBAs face an increasingly complex number of data connections to manage. With the factoring in of necessary updates driven by day-to-day administration — updated port number, temporary relocation, additions, etc. — comes the need for constant communication between DBAs and their consumers.

To reduce the human communication and data management overhead, the new IBM Data Studio capability allows DBAs to centrally manage and share the data connection information from the IBM Data Studio web console. The information will then be easily distributable to all Eclipse-based Data Studio clients.


Defining connections in the Data Studio web console

Upon starting the IBM Data Studio web console, new database connections can be easily defined by using the dedicated Databases page, in the top-left corner.

Figure 1. Databases area lets you manage your database connections
Image shows Databases area

From the Databases page, database connections can be fully managed. You can add, test, edit, delete, and group the database connection.

Figure 2. Adding a connection to the Data Studio web console
Image shows adding a connection to the Data Studio web console

The figure below displays the new connection added within the web console.

Figure 3. Connection displayed within the IBM Data Studio web console
Image shows the new connection added in the web console

Importing connections in IBM Data Studio

After you define a database connection in the IBM Data Studio web console, you can import the connection into the IBM Data Studio full or admin client. The first step is to configure the web console URL location. You can easily configure the web console through a shortcut in the Task Launcher interface. In the Monitor tab, click Configure the Data Studio web console URL and preferences. On the Preferences page that appears, you configure the web console simply by providing its URL. As the credentials will never be shared, you do not need to provide any authentication information.

Figure 4. Configure the Data Studio web console URL
Image shows configuring the Data Studio web console URL

Configuring the web console is as simple as a single URL. As credentials will never be shared, authentication is not required.

Figure 5. Data Studio web console URL preference
Image shows Data Studio web console URL preference

Troubleshooting

If you cannot get your connections to display within the Administration Explorer, the URL may be invalid or you may be disconnected. You could validate it by pasting it within your browser.

You can import database connections into the Data Studio client by clicking on the Import action from the Administration Explorer toolbar. This allows all IBM Data Studio web console connections to be locally replicated. You do not need to modify the web console URL in the Import dialog since the dialog automatically picks up the URL you previously set from the Preference page.

Figure 6. Importing web console connections
Importing web console connections

After you click the Import Connection Profiles dialog, the connections will be added to the Administration Explorer. As credentials are not imported, the username and password properties will need to be filled by the user at connection time. Alternatively, you can use the new Change User Names and Passwords dialog to manage all credentials within a common interface.

Figure 7. Usernames and passwords need to be set on imported connections
Image shows that usernames and passwords need to be set on imported connections
Figure 8. Managing credentials on imported connections
Image shows managing credentials on imported connections
Figure 9. Connected connection displayed in the Administration Explorer after import
Image shows connection displayed in Administration Explorer after import

Managing connections within the Data Studio client

In this initial release of the solution, updates made within the Data Studio web console will not transparently be retrieved by each Eclipse client. Following the steps of the import scenario, subsequent refreshes will follow a similar path, as detailed below. Within the IBM Data Studio web console, individual connections can be edited, for instance, to specify an updated port number.

Figure 10. Editing connections within the IBM Data Studio web console
Image shows editing connections within the IBM Data Studio web console

To refresh the imported connections of the Administration Explorer, the import dialog will be brought again (see Figure 6). Once dismissed, the following reconciliation will be processed:

  • Connections removed within the IBM Data Studio web console will be left unchanged within the IBM Data Studio Eclipse clients.
  • Connections added within the IBM Data Studio web console will be added to the requesting IBM Data Studio Eclipse client.
  • Imported fields of previously imported connections are being evaluated for update. New imported values will unconditionally override existing values. Note that the username and password values are not imported, so they cannot be overridden.

Conclusion

In this article, we have reviewed how the IBM Data Studio portfolio, bringing an intuitive solution to sharing and maintaining updated connections among a wide network of Data Studio clients.

Resources

Learn

Get products and technologies

Discuss

Comments

developerWorks: Sign in

Required fields are indicated with an asterisk (*).


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 


The first time you sign into developerWorks, a profile is created for you. Information in your profile (your name, country/region, and company name) is displayed to the public and will accompany any content you post, unless you opt to hide your company name. You may update your IBM account at any time.

All information submitted is secure.

Choose your display name



The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

Required fields are indicated with an asterisk (*).

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 


All information submitted is secure.

Dig deeper into Information management on developerWorks


static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=772918
ArticleTitle=Managing database connections with the IBM Data Studio web console
publish-date=11102011