# import-from-oracle

## Description

<mark style="color:purple;">`import-from-oracle`</mark> *adaptor imports data from an Oracle database and returns the results as a datatable in Data-flo.*

This adaptor allows users to set up a connection to an Oracle database, set a query, and extract data from the database into a Data-flo datatable.

## Inputs

**`connection string`**\
Type: `text`\
Required: Yes\
An Easy Connect string (e.g., hostname:port/service), a Connect Descriptor string, or the SID of a local Oracle Database instance.

**`username`**\
Type: `text`\
Required: No\
The username to connect to the database.

**`password`**\
Type: `text`\
Required: No\
The password to connect to the database.

**`query`**\
Type: `text`\
Required: Yes\
The SQL query reading from the database (e.g. `SELECT * from table WHERE ...`).

## Outputs

**`data`**\
Type: `datatable`\
A datatable containing the imported data.

## Examples

### Example 1: Default behaviour.

#### Inputs:

`connection string:` localhost:1521/demoDB

`username:` demo\_user

`password:` demo\_password

`query:`

```
SELECT 1 AS field1, 'a' AS field2
UNION
SELECT 2 AS field1, 'b' AS field2
UNION
SELECT 3 AS field1, 'c' AS field2
```

#### Outputs:

`data`:

| field1 | field2 |
| ------ | ------ |
| 1      | a      |
| 2      | b      |
| 3      | c      |

-> Imported data from Oracle database into Data-flo.