Using Oracle Wallet in FME Flow

Introduction

In FME, you can directly upload your Oracle Autonomous Wallet credentials to both FME Form and FME Flow. 

For instructions on how to use Oracle Wallet in FME Form, please see the bottom of Connecting to Oracle Autonomous Databases. This tutorial will walk you through adding Oracle Wallet credentials and creating a Database Connection in FME Flow. 

Requirements

• Oracle Client and SQL*Plus Packages 18.5 or higher
• Oracle Autonomous Database
• FME Flow

Step-by-step Instructions

Before you begin, ensure that you have access to an Oracle Autonomous database as well as have installed an Oracle Client 18.5 or higher on the same machine as FME Flow. For details on how to set this up, please see How to setup an Oracle Instant Client for use with FME.

1. Provision Oracle Autonomous Database

Provision Oracle Autonomous Database, either Autonomous Database Warehouse (ADW) or Autonomous Transaction Processing (ATP), and download the corresponding credentials.zip file to the same system that has FME installed. For the Oracle documentation to provision, ADW, click here. For Oracle documentation on provisioning ATP, click here. Also, check Downloading Client Credentials (Wallets).

2. Upload Oracle Wallet to FME Flow Resources

Log in to FME Flow with a user who has permissions to upload files to the Resources folder and create a database connection. 

Browse to the Resources folder located under Files & Connections on the side menu bar. In the Resources folder, navigate to the Data folder. Here, you can create a new folder if desired. For this example, we will simply upload to the Data folder. 

In the Data folder, click on the Upload button, then select Files. Browse to your downloaded Oracle Wallet credentials and upload the zipped file containing the credentials. 

3. Create a Database Connection

Navigate to the Database Connections located under Files & Connections. Click on the New button to create a new connection. 

Name the connection 'Oracle Autonomous,' then select 'Oracle' as the Type. Change the Connection Mode to Cloud Wallet. Add the connection Username and Password if you have one. 
For the Cloud Wallet File, database connections cannot use the macros ( e.g., $(FME_SHAREDRESOURCE_DATA)), so you will need to add the direct path to the resource. 

In Windows, the Resource folder can be found in:

%ProgramData%/Safe Software/FME Server/resources

In Linux, it is found in:  

<FME Flow Install Dir>/resources 

For this example, our ProgramData is found in the C: drive, so our path is:

C:\ProgramData\Safe Software\FME Flow\resources\data\Wallet_SAFE.zip  

Finally, set your Wallet Service to the service name found in the tnsnames.ora file found in the credentials zip file. For more information on Wallet Service, refer to Step 5 in "Connecting to Oracle Autonomous Databases ." 

4. Publish a Workspace

In FME Form, publish a workspace that contains an Oracle Autonomous Writer to FME Flow. Ensure that the workspace has the Oracle Autonomous Connection set up as a published parameter. If you need a demo workspace, you can download WritingToOracleAutonomous.fmwt from the Files section. 

5. Run Workspace on FME Flow

Back in FME Flow, navigate to the Run Workspace page. Select the workspace that was uploaded in the previous step, then set the Connection to Oracle Autonomous. If your workspace fails, review the troubleshooting section at the bottom of this article for guidance. 

Alternative Method

Alternatively, instead of creating the database connection in FME Flow, you can also create the connection in FME Form and upload the connection when you publish the workspace. The parameters are exactly the same. 

Troubleshooting

Incorrect/Missing Username or Password

If your username or password is incorrect or missing, you will get the error ORA-01017 in the job log file. If this occurs, confirm that you entered the correct username or password. If you have the correct username and password but are still seeing these errors, please contact your database administrator.

Could not find Cloud Wallet file

If you receive the error “Could not find Cloud Wallet file” in the job log file, confirm that the Wallet credentials have been uploaded to the FME Flow Resources folder. After confirming that they have been uploaded, double-check the path to the folder to ensure it is correct. See Step 3 for data locations. 

Other Errors

If you receive other errors not listed here, please check the Troubleshooting section at the bottom of Connecting to Oracle Autonomous Databases. If your error message is not there, please contact Safe Support.