--- title: "Data Source - Oracle Database" slug: "data-source-oracle-database" updated: 2024-09-19T08:14:15Z published: 2024-09-19T08:14:15Z canonical: "documents.trocco.io/data-source-oracle-database" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.trocco.io/llms.txt > Use this file to discover all available pages before exploring further. # Data Source - Oracle Database ## summary Help page for ETL Configuration from Oracle Database. ## Setting items ### STEP1 Basic settings | (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 Transfer****using the query**. For more information on [Incremental Data Transfer](/docs/incremental-data-transfer), see [Incremental Data Transfer Function](/docs/incremental-data-transfer). | | 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. | #### STEP1 detailed settings 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. :::