How to map data from an Oracle data source

This procedure assumes you have already created an Oracle database connection.

1	Define the target database and table.

1	In Options, choose New from DB. Table Declaration appears, as shown in Figure 3-29.

Figure 3-29

Declaring a table from a database

2	In Table Declaration, choose the target database from the drop-down list, as shown in Figure 3-30.

Figure 3-30

Mapping data from an Oracle database

3	In Name, specify the name of the target table.

4	In Description, enter the table description.

5	In Action, choose Create.

6	Select Overwrite.

2	Define the data set.

1	In Datasource, choose the database data source.

2	In Query, choose View database structure to build the query. Datasource appears.

In Datasource, choose a table from the table drop-down list. The column names appear, as shown in Figure 3-31.

Use + and - to add or remove columns, and the up and down arrows if you need to change the column order.

In Datasource, choose OK. The column definitions appear, as shown in Figure 3-31.

Figure 3-31

Using the query builder

3	In Options, specify any options you wish to pass to the data driver.

3	Choose View to validate the data connection and view the data. Query results appears, as shown in Figure 3-33.

Figure 3-32

Figure 3-33

Viewing data from a database

4	Choose Get columns to import the columns from the data set. The column definitions appear as shown in Figure 3-34. The types are determined automatically, and all columns are indexed by default. Get columns overwrites the existing data set, and discards your existing changes.

Figure 3-34

Getting the column definitions from the data set

5	Edit a column.

The example in Figure 3-35 shows changing the format of the HIREDATE column, and setting the column as not indexed.

Figure 3-35

Editing a Datetime column

1	Select the HIREDATE column and choose Edit.

2	In Type, select Date format.

3	In Format, select mm_dd_yyyy from the drop-down list.

4	Deselect Indexed. Choose OK.

6	In Project, choose Save. Choose Yes to save the project.

 

Copyright Actuate Corporation 2013

BIRT Analytics 4.2