Export data from Oracle Autonomous Database (ADB)

You can create an export from Oracle Autonomous Database (ADB) in either of these ways:

• as part of a flow while designing or building your flow (Flow builder > Add source app)

– or –

• as a resource that you can later attach to a flow (Resources > Exports)

Tip: The navigation paths differ, but the exporting task is the same.

Creating an export from Oracle ADB consists of the following two logical parts: providing general details and configuring the export.

Contents

• Provide general details
  • Option A: Add/create a source in a flow
  • Option B: Create an export resource
• Configure your export
  • Configure required settings

Provide general details

You can start creating an export from Oracle ADB and provide essential/general details in either of these ways:

Option A: Add/create a source in a flow

1. From the main menu, select Tools > Flow builder.
2. In the Flow builder, click the plus sign () next to Source.

3. In Create source, for Application, select Oracle Autonomous Database.
4. For What would you like to do?, the default is Export records from source application.
5. For Connection, select a previously created Oracle ADB connection from the drop-down menu, or you can click Create connection and create one if you haven't done so already.
6. Click Next.

– or –

Option B: Create an export resource

1. From the main menu, select Resources > Exports.
2. Click + New export.

3. In Create export, for Application, select Oracle Autonomous Database.
4. For Connection, select a previously created Oracle ADB connection from the drop-down menu, or you can click Create connection and create one if you haven't done so already.
5. For Name, enter a meaningful name based on the purpose, function, or any other aspect.
6. For Description, optionally provide details that will help in understanding your export.
7. Click Next.

Note: You've completed providing the general details. Next, you must configure the required settings in the export.

Configure your export

You can use standard SQL queries to export and modify data. If your flow requires multiple SQL queries, you must create one export for each query. You can't use multiple SQL queries on a single export.

For Oracle ADB, you must configure the required settings in General, What would you like to export? and Configure export type sections for data to be exported successfully. (You can configure the optional settings as required for any customization.)

Configure required settings

1. In Name your export, enter a meaningful name for your export based on the purpose, function, or any other aspect. 

Note: If you've used the Resources > Exports path to create an export, then this value is automatically filled in.

2. For SQL query, click the Edit icon () and enter your SQL statement based on what you want to export from Oracle ADB.

3. For Export type, select an option based on how you want to export records. See Four different export types to retrieve data. If you're using Delta as the Export type, for the date, you must provide the data type explicitly. For example,
   SELECT * FROM TableName WHERE joining IS NOT NULL AND joining TO_TIMESTAMP({{lastExportDateTime}},'YYYY-MM-DD"T"HH24:mi:SS.FF3"Z"') ORDER BY id
4. Click Preview to check the export to see sample JSON-formatted data. If the SQL query is not executed successfully, revise the Query or Export type values.
5. Click Save.

When an export is saved,

• if you've created it in a flow, the export is added to your flow in Flow builder.
• if you've created it as a resource, then it is added under Resources > Exports.