Skip to main content
Question

how could i configure Oracle reader to connect with the data and read it ?


spiderman
Contributor
Forum|alt.badge.img+7

i have oracle data, how could i configure it to read the data from it .

i am not sure how to connect with and read the data

parameter available :

user and password and Host and port no. and service name

 

FME 2018

3 replies

redgeographics
Celebrity
Forum|alt.badge.img+50

The Oracle Reader will allow you to enter those credentials (database, username and password) in a Database Connection. That way you only need to enter them once.

 

This clip is a bit older and about PostGIS, but the steps for Oracle are essentially the same.


spiderman
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • July 28, 2021
redgeographics wrote:

The Oracle Reader will allow you to enter those credentials (database, username and password) in a Database Connection. That way you only need to enter them once.

 

This clip is a bit older and about PostGIS, but the steps for Oracle are essentially the same.

i have tried many times but i am still always hav error .

Error :

Environment variable ORACLE_HOME is not set.

Failed to obtain any schemas from reader 'ORACLE_NONSPATIAL' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading.

what should i do ?


redgeographics
Celebrity
Forum|alt.badge.img+50
spiderman wrote:

i have tried many times but i am still always hav error .

Error :

Environment variable ORACLE_HOME is not set.

Failed to obtain any schemas from reader 'ORACLE_NONSPATIAL' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading.

what should i do ?

Have you installed the Oracle Client on your local machine?

 

See the Oracle Troubleshooting Guide for more information.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings