Database Reference
In-Depth Information
Working with targets
We have seen in the earlier section that PowerCenter can use different types of sources.
Similarly, PowerCenter is capable of working with different types of targets to load data.
The targets are explained as follows:
•
Relational database
: PowerCenter supports all the relational databases such as
Oracle, Sybase, DB2, Microsoft SQL Server, SAP HANA, and Teradata
•
Files
: PowerCenter supports flat files (fixed-width and delimited files), COBOL
files, XML files, and Excel files
•
High-end applications
: PowerCenter also supports applications such as Hyperion,
PeopleSoft, TIBCO, WebSphere MQ, and so on
•
Mainframe
: Additional features of Mainframe such as IBM DB2 OS/390, IBM
DB2 OS/400, IDMS, IDMS-X, IMS, and VSAM can be purchased
•
Other
: PowerCenter also supports Microsoft Access and external web services
Working with target relational database tables - the Import
option
As we discussed about importing and creating source files and source tables, the same way,
we need to work on target definitions.
The process of importing the target table is exactly the same as importing the source table;
the only difference is that you need to work in
Target Designer
.
You can import or create the table structure in
Target Designer
. After you add these target
definitions to the repository, you can use them in a mapping.
Perform the following steps to import the table target definition:
1. In the designer screen, navigate to
Tools
|
Target Designer
to open the Target
Designer screen.
2. Navigate to
Targets
|
Import from Database
.
3. From the ODBC data source button, select the ODBC data source that you created
to access the source tables. We have already added the data source while working
on the sources.
4. Enter the username and password to connect to the database.
5. Click on
Connect
.
6. In the
Select tables
list, expand the database owner and the
TABLE
heading.
7. Select the tables you wish to import and click on
OK
.