 | Getting started with the Informix Warehouse Client
Launching Design Studio
- Select Start > All Programs > IBM
Informix Warehouse Feature > DesignStudio.
Figure 6.
Launching the Informix Warehouse Client from Start
menu
Alternatively, you can launch Design Studio's Eclipse IDE by
running the command eclipse.exe
from C:\Program Files\ISWarehouse\ds\ (default location of
Design Studio on Windows) or from your actual Design Studio
directory.
On UNIX, this tends to be installed at /opt/IBM/ISWarehouse.
The Informix Warehouse Feature Client can be launched from
/opt/IBM/ISWarehouse/ds/ by executing the command
eclipse.
- When the following Workspace Launcher window appears, change the
name of the workspace to workspace_demo and click
OK.
Figure 7.
Informix Warehouse Feature Client splash screen
- A Welcome screen is shown after the workspace is created for the
first time. Close the screen, as shown in Figure 8:
Figure 8.
Closing the Welcome screen
The newly created (blank) workspace will appear, as depicted
in Figure 9:
Figure 9. A
blank workspace
Now you're ready to start working with Design Studio. In the next steps
you will identify and define the connections and data models of the
databases participating in the DW/ELT project.
Defining the database connections
|
Data warehousing project in
Informix Warehouse
This tutorial uses DW/ETL or DW/ELT Project to reference the type
of warehousing application that will be developed using Design
Studio. Informix Warehouse allows you to create, design, test, and
debug what this tutorial calls Data Warehousing applications or projects, to
include the Data Models of the source and target databases (or its
set of tables involved in the data movement and transformation
project), the database connections involved, the Data Flows and
Control Flows, File Formats, SQL Scripts, and other objects
related to projects for extracting-loading-and-transforming data
from different heterogeneous sources to populate a data warehouse
repository (in Informix).
|
|
In order to start working with databases in your data warehousing
application (ELT project), you need to create and test the database
connections to the different databases participating in this project
as either source or target systems (in this case, the connections to
both sample databases stores_demo and sales_demo).
Create two new database connections (one for sales_demo and
another one for stores_demo) using the Informix JDBC
driver®. Optionally, you can use the
IBM Data Server Driver for JDBC and SQLJ. This tutorial connects using
the Informix JDBC driver.
- On the Data Source Explorer tab, right-click on Database
Connections > New…
Figure
10. Creating a new database connection
A New Connection wizard screen appears.
Figure
11. New Connection wizard
|
Updating Informix JDBC®
Driver
Informix Warehouse Feature 11.50 comes with Informix JDBC Driver
3.50.JC2. We strongly advise you to update to JDBC 3.50.JC3 or
later. You can do this by clicking on the little triangle icon,
located on the right of the JDBC Driver option, and editing the
driver properties.
|
|
- Since this tutorial uses the Informix database and Informix
JDBC® driver, select Informix under the Select a
database manager option and click on the drop-down menu
under the JDBC driver option to select Informix 11.5 –
Informix JDBC Driver Default.
Figure 12.
New Connection wizard, part 2
- One database at a time, fill out the connection information for
both stores_demo and sales_demo database
connections. Test the connections to ensure your database
connection information is correct and that you are able to connect
to both databases. (Figures 13 and 14 illustrate the steps for the
stores_demo database only.)
Figure
13. Testing the new connection
- Click on Next to edit the filtering
option.
- Uncheck the box next to Disable filter to allow filtering.
Click on the radio button next to Selection. Check the box
next to admin, the user that was used when creating the
database (if you used a different user, check that option
instead).
Figure
14. Using filter option to select admin schema
|
Important
Make sure all the database connections are online (you are
connected to both data sources) in the Data Source Explorer.
|
|
- Click on Finish. A new database connection is created on
the Data Source Explorer panel, as depicted in
Figure
15.
- Follow the steps above for both the stores_demo and the
sales_demo databases. Figure 15 shows that both
connections are created and alive:
Figure 15.
Data Source Explorer showing both connections created and
active
You can browse through the objects of the databases on
the Data Source Explorer panel on the left side and see the
properties of the database connection's objects in the Properties
window on the right side of the workspace.
Creating a new DW / ELT project in Design Studio
Now, let's create a new project for our data warehouse and its ELT
jobs.
Notice the Data Project Explorer located in the upper left panel, as
shown in Figure 16. It should be empty.
Figure 16. Data
Project Explorer
- To create the Data Warehousing project, click on File
> New > Data Warehousing Project
Figure
17. Creating Data Warehousing project
The New Project wizard screen appears.
- Enter
Sales Demo - ELT and DW Project
in the Project name field.
Figure
18. New Project wizard
- Click on Finish. The new project now appears on the left
side, under the Data Project Explorer.
Figure
19. New project is created
In the next step, you're going to generate the data model for the
existing OLTP database stores_demo using reverse engineering to
discover it and pick up just the tables you need for the DW/ELT
project and visualizing them in an ER representation.
| |
