Rational Data Architect and DB2 9: The Database Explorer
April 17, 2007
In a previous series of articles, Ive written about the tight integration of the IBM DB2 9 for Linux, UNIX, and Windows data server and its impressive integration with some of the worlds most popular integrated development environments (IDEs) such as IBM Rational Application Developer and Microsoft Visual Studio .NET. One area Ive not covered is integration with an IDE for data architects--the IBM Rational Data Architect (Rational DA) product.
Rational DA is an enterprise data modeling and integration design tool that can simplify the role of data architects who work with diverse and distributed data assets. For example, using Rational DA, you can create logical and physical data models. You can discover, explore, and visualize the structure of data sources. You can discover potential relationships and identify relationships (through mapping) between disparate data sources. You can compare and synchronize the structure of two data sources and targets. You can analyze models and data sources for conformance to enterprise standards, generate SQL/XML statements, and lots more.
If you looked at all the capabilities provided by Rational DA, you could logically group them into the following categories:
In this series, I want to take you through the various interfaces of the Rational DA IDE as they relate to DB2 9 data servers and tasks that you can accomplish with this wonderful tool, such as the generation of a database glossary for conformance purposes.
Because Rational DA is based on the Eclipse 3.2 framework, if youve read my articles about Rational Application Developer, youll find yourself off to a good start, but its not a prerequisite for this series.
In my coverage of Rational DA, I assume that youre working within the Data perspective unless I explicitly name a different perspective. The Data perspective is shown below:
If you dont see this perspective in the top-right corner of the IDE, click Open Perspective () --> Other, and select the Data perspective (you may need to select Show All to see this perspective):
This series also assumes that you have the SAMPLE database created on your data server with the XML extensions. If you dont, you can create it by entering the db2sampl -xml command from your operating systems command prompt.
If you dont have a copy of DB2 9, you can download a free trial copy of DB2 Enterprise 9 or the free to use, build, test, and deploy version, DB2 Express-C 9. (A free trial copy has an expiration date on the code and cant be used for production, whereas DB2 Express-C 9 you can actually use indefintately and for production purposes.)
You can see in the following figure that Ive already added a number of data server connections to my Database Explorer view in Rational DA:
You can also see that I have a current connection to a SAMPLE database located in an Apache Derby 10.0 data server (noted by the green icon); however, this is not the SAMPLE database in DB2 9 created by the prerequisite db2sampl -xml command for this article.