ODI Data Extraction Tutorial _01 setting up a data source

According to the previous environment to build steps, ODI environment has been completed, the agent also configured successfully.
Now start learning the steps of the data pump.

The first step: Set the extracted data source and target data source

1, the first to have two databases, one is to provide the source data database, can be any type of ODI support, SQL Server, Oracle, MySQL, hive can be, here to Orale as an example, the target database is also Oracle, A follow-up will write about how to extract the data from the MongoDB database.

2, new data server. The main point here is to establish a connection to the database, specifying the URL and username password.
"Topology" – "Physical Architecture" – "Technology", select the appropriate database technology, right-click "New Data Server" and fill in the appropriate configuration information

3, according to the format to fill out the relevant information JDBC

4. Set up the physical scheme for the database server, right-click the "New physics scheme", set up the scheme and work plan for the corresponding users of the database (in the process of data extraction, the corresponding temporary tables and triggers will be established under the change user).

5. Enter the name of the logical scheme on the "context" and the system will automatically establish a logical scheme.

6. The above steps set up information about the database server, and then the model of the database is set up.
"Designer"-"model"-"New Model"
On the right side of the interface select the corresponding logical scheme.

7, at this time the database model has been completed, you can open the database model, in the right edit window to select "Reverse engineering" or "selective reverse engineering", the database table synchronization to the database model below, easy to design later.

After the database model is established and the related tables are synchronized, the following tables can be used to design the extraction process directly.

The data source model for the target database is also set.