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
Question
how could i configure Oracle reader to connect with the data and read it ?
+62- Celebrity
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.
+7- Contributor
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 ?
+62- Celebrity
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.