From Oracle
If the source link of a job is the Link to an Oracle Database, configure the source job parameters based on Table 1.
Category |
Parameter |
Description |
Example Value |
---|---|---|---|
Basic parameters |
Use SQL Statement |
Whether you can use SQL statements to export data from a relational database |
No |
SQL Statement |
When Use SQL Statement is set to Yes, enter an SQL statement here. CDM exports data based on the SQL statement.
NOTE:
|
select id,name from sqoop.user; |
|
Schema/Tablespace |
Name of the schema or tablespace from which data will be extracted. This parameter is displayed when Use SQL Statement is set to No. Click the icon next to the text box to go to the page for selecting a schema or directly enter a schema or tablespace. If the desired schema or tablespace is not displayed, check whether the login account has the permissions required to query metadata.
NOTE:
The parameter value can contain wildcard characters (*), which is used to export all databases whose names start with a certain prefix or end with a certain suffix. For example:
|
SCHEMA_E |
|
Table Name |
Name of the table from which data will be extracted. This parameter is displayed when Use SQL Statement is set to No. Click the icon next to the text box to go to the page for selecting the table or directly enter a table name. If the desired table is not displayed, confirm that the table exists or that the login account has the permissions required to query metadata. This parameter can be configured as a macro variable of date and time and a path name can contain multiple macro variables. When the macro variable of date and time works with a scheduled job, the incremental data can be synchronized periodically. For details, see Incremental Synchronization Using the Macro Variables of Date and Time.
NOTE:
If you have configured a macro variable of date and time and schedule a CDM job through DataArts Studio DataArts Factory, the system replaces the macro variable of date and time with (Planned start time of the data development job – Offset) rather than (Actual start time of the CDM job – Offset).
NOTE:
The table name can contain wildcard characters (*), which is used to export all tables whose names start with a certain prefix or end with a certain suffix. The number and types of fields in the tables must be the same. The examples are as follows:
|
table |
|
Advanced attributes |
Partition Column |
This parameter is displayed when Use SQL Statement is set to No, indicating that a field used to split data during data extraction. CDM splits a job into multiple tasks based on this field and executes the tasks concurrently. Fields with data distributed evenly are used, such as the sequential number field. Click the icon next to the text box to go to the page for selecting a field or directly enter a field.
NOTE:
|
id |
WHERE Clause |
WHERE clause used to specify the data extraction range. This parameter is displayed when Use SQL Statement is set to No. If this parameter is not set, the entire table is extracted. You can set a date macro variable to extract data generated on a specific date. For details, see Incremental Migration of Relational Databases.
NOTE:
If you have configured a macro variable of date and time and schedule a CDM job through DataArts Studio DataArts Factory, the system replaces the macro variable of date and time with (Planned start time of the data development job – Offset) rather than (Actual start time of the CDM job – Offset). |
DS='${dateformat(yyyy-MM-dd,-1,DAY)}' |
|
Null in Partition Column |
Whether the partition column can contain null values |
Yes |
|
Extract by Partition |
When data is exported from an Oracle database, data can be extracted from each partition in the partitioned table. If this function is enabled, you can configure Table Partition to specify specific Oracle table partitions from which data is extracted.
|
No |
|
Table Partition |
Oracle table partition from which data is migrated. Separate multiple partitions with ampersands (&). If you do not set this parameter, all partitions will be migrated. If there is a subpartition, enter the partition in the Partition.Subpartition format, for example, P2.SUBP1. |
P0&P1&P2.SUBP1&P2.SUBP3 |
|
Job Split Field |
Used to split a job into multiple subjobs for concurrent execution. |
- |
|
Minimum value of a split field |
Specifies the minimum value of Job Split Field during data extraction. |
- |
|
Maximum Split Field Value |
Specifies the maximum value of Job Split Field during data extraction. |
- |
|
Number of subjobs |
Specifies the number of subjobs split from a job based on the data range specified by the minimum and maximum values of Job Split Field. |
- |
When an Oracle database is the migration source, if Partitioning Field or Extract by Partition is not configured, CDM automatically uses the ROWIDs to partition data.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.