Skip to main content

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

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.


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 ?


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.


Reply