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
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?
+12- Contributor
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!
+12- Contributor
gerhardatsafe wrote:
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.
oliver.morris wrote:
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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.