Using Oracle Wallet in FME Server

Liz Sanderson
Liz Sanderson
  • Updated

FME Version

  • FME 2021.0

Introduction

In FME 2020.1, we added support for Oracle Autonomous, now in FME 2021, you can directly upload your Oracle Autonomous Wallet credentials to both FME Desktop and FME Server. 

For instructions on how to use Oracle Wallet in FME Desktop, 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 Server. 


Requirements

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


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 Server. 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 the Oracle documentation to provision ATP, click here. Also, check Downloading Client Credentials (Wallets).
 
2. Upload Oracle Wallet to FME Server Resources
Log into FME Server with a user that has permissions to upload to the Resources folder as well as 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 just be uploading 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 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 Server Install Dir>/resources 

For this example, our ProgramData is found in the C: drive so our path is:
C:\ProgramData\Safe Software\FME Server\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, see Step 5 in Connecting to Oracle Autonomous Databases

 
4. Publish a Workspace
In FME Desktop, publish a workspace that contains an Oracle Autonomous Writer to FME Server. 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 Server
Back in FME Server, 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. 
 

Alternative Method

Alternatively, instead of creating the database connection in FME Server, you can also create the connection in FME Desktop 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 or password, but you are still seeing these errors, speak to 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 Server Resources folder. After confirming that they have been uploaded, double-check the path to the folder. 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
 

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.