Data Source - Oracle Database

Article summary

Did you find this summary helpful?

Thank you for your feedback

summary

Help page for ETL Configuration from Oracle Database.

(data) item	indispensable	default value	Contents
Oracle Database Connection Configuration	Yes	-	Select the previously registered Connection Configuration that has the necessary permissions for this ETL Configuration.
database (Name of online service)	Yes	-	Specify the name of the database containing the data you wish to transfer. * If you choose Connection Configuration using the tnsnames.ora file, please specify the net service name.
Transfer Method	Yes	Transfer using query	Select either Transfer or Incremental Data Transferusing the query. For more information on Incremental Data Transfer, see Incremental Data Transfer Function.
query	Yes	-	Enter if you selected transfer using query as the transfer method. Enter SQL to retrieve transfer data.
schema	No	-	This can be entered when Incremental Data Transfer is selected as the transfer method. Specify the schema that contains the table you want to transfer. If unspecified, it will be the DB user's default schema.
table	Yes	-	Enter if Incremental Data Transfer is selected as the transfer method. Enter the name of the table containing the data you wish to transfer.

Clicking on "Set Details" will display the following configuration items

fetch data type specification
Data in specified columns can be converted to string type and transferred.
item name indispensable default value Contents
column name Yes - Enter the name of the column to be converted to a string type.
data type Yes string -
:::( Info) (String type conversion use case)
TROCCO will convert the Data Source data to a specific data type before importing the data.
Therefore, data of some data types may be missing during import.
In such cases, missing data may be avoided by converting to a string type.
For example, a decimal type value with 20 total digits (e.g., 1234567890.0123456789 ) is captured by TROCCO as a double type during transfer.
However, the total number of digits that can be handled by the double type in TROCCO's transfer execution environment is approximately 15, so the above numerical data is missing.
At this time, by using string type conversion, Data Source can be transferred with no loss of data and maintaining the original number of digits.
:::

item name	indispensable	default value	Contents
column name	Yes	-	Enter the name of the column to be converted to a string type.
data type	Yes	string	-

Was this article helpful?

Table of contents