![]() ![]() Some Connection Name, say XXCUST_ADW_DB_CONNĮXPERT TIP : You could connect to a Local File Server to read file & a local database to insert data as well.Go to Connections -> ATP Adapter -> Provide You are then asked to upload the DatabaseWallet.zip, provide the Wallet password &.You could also access ADW database from Oracle SQL Developer to run SQLs. To connect to a cloud based ADW database, Oracle provisions you a wallet.zip file – which contains a file with service names like TNSNAMES.ora. We need another connection now logically. When we read the data from the file, we then insert data in a Cloud Database (say an ADW database). ![]() Some Connection Name, say XXCUST_SFTP_OIC_CONNĢ.Go to Connections -> FTP Adapter -> Create Connection ->Provide the Following Values So one connection would suffice for both the scenarios. In this case, SFTP connection is TRIGGER (You can create TRIGGER & INVOKE as well – if you ultimately want to place a file in SFTP server again). INVOKE – What we invoke from the integration (target) We will need a SFTP Adapter Connection first to be created in order to connect to SFTP Server. Insert Data to a cloud database table (say ADW Database) Read/Access the file in the local OIC Server Area. Reading a File (csv or other) from a SFTP location or a local file server and performing any actions with the data such as passing it on to Oracle Fusion (SaaS) or transform the data and place it at any destination.ĭefine the logical flow with the end points first.Īccess CSV file in the SFTP Server from OIC.ĭownload the File to local OIC Server Area. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |