Hi, I have an oracle db I would like to connect to from FME Cloud. I can reach it on desktop but I have the client installed locally. Can anyone point me to a link on how to connect, I have had a look but couldnt find anything.
Thank you
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- 8391 replies
First, I doubt that the required Oracle client is already installed on the FME Cloud instances, you'll probably have to contact Safe to verify that.
Secondly, where is your Oracle instance running? On your local network or in some cloud? If it's on your local network, are you sure that it's reachable through your firewalls?
+14- Contributor
- 176 replies
ok thanks @david_r yes the oracle instance is reachable, I just dont know how it accesses oracle without the tnslistener settings somewhere.
Hi @olivermorris ,
FME Cloud comes with the Oracle client installed. As long as your DB allows access from the FME Cloud instance you should be able to read and write by using the database connection that you use on FME Desktop.
FME Cloud is in a public network, so your database needs to be publicly available. As a best practice, I recommend to assign a static IP to your FME Cloud instance and restrict public access to your DB to this IP.
If you still have trouble to connect I would recommend opening a support ticket with a detailed description of the error and all related log files and/or screenshots attached.
I hope this helps!
+14- Contributor
- 176 replies
Hi @olivermorris ,
FME Cloud comes with the Oracle client installed. As long as your DB allows access from the FME Cloud instance you should be able to read and write by using the database connection that you use on FME Desktop.
FME Cloud is in a public network, so your database needs to be publicly available. As a best practice, I recommend to assign a static IP to your FME Cloud instance and restrict public access to your DB to this IP.
If you still have trouble to connect I would recommend opening a support ticket with a detailed description of the error and all related log files and/or screenshots attached.
I hope this helps!
user/password@//hostname:port/service_name
Leaving the username and password fields blank.
- 8391 replies
Thank you! After a bit or tinkering I got it to work using the following format
user/password@//hostname:port/service_name
Leaving the username and password fields blank.