To begin, a BIG thank you to my colleague Prakash M. here.
This scenario covers the bulk load of data into ATP from an ftp server. I'v got a file full of orders and need to get them into my DB ORDERS table asap. With the May 21 release, the OIC ATP has been powered to do just this.
The diagram below shows the flow -
OIC reads the file via the ftp adapter. Then the ATP adapter does the magic - stores the file in my OCI Object Storage Bucket and then loads the data from there into ATP via the DBMS_FILE.COPY_DATA procedure.
So here are all the parts - I use the bucket - bucketNC.
OCI Object storage.
Here is my DB table -
Here is the orders data - this is a .csv file
So let's get those orders from the csv file into the ORDERS table.
Firstly to OCI...
The ATP adapter has been augmented to allow connectivity over OCI - there is a new security option available - JBDC With OCI Signature. The configuring of this option will require some information from your OCI setup -
Here are the keys I will use - please refer to my previous post on OCI for details on how to generate keys.
- Tenancy OCID
- Compartment OCID
- User OCID
- API Fingerprint