Hello,
I need to connect Losant IoT Platform to Oracle Database 19c in order to read process data from an oracle view. Is there any docs regarding this?
Thank you,
Lucas Klink
Hey @Lucas_Klink, welcome to our forums!
Our SQL Node currently supports MSSQL, MySQL, PostgreSQL, and SQLite (edge only). It does not currently support Oracle. The underlying driver we use for SQL communication does support Oracle, so it is something we can investigate.
Are you attempting to communicate with the database from an Edge Workflow or an Application/Experience Workflow?
The reason I ask is that cloud-to-cloud database connections can be tricky from an IT/security perspective. If you’re using an Edge Workflow, then the gateway is running on your own network, which can be more acceptable for your IT dept.
Hi @Brandon_Cannaday ,
thank you for your prompt response.
It’s a cloud-to-cloud connection, we are running an Application/Experience Workflow. No Edge devices being used.
How do you recommend us to proceed on this case?
I recommend invoking a cloud function, which can then perform the necessary query against your Oracle database. From a security perspective, this is a better approach than directly accessing a database cloud-to-cloud. We have several built in cloud function nodes.
If you’re not using one of these, almost every cloud function supports HTTP invocation, which can be done using the HTTP Node.
That makes sense.Thank you.
In a scenario that we have an Oracle DB on premises, that would be the same recommendation, right?
You can also look into Oracle REST Data Services, which allows you to interact with your Oracle database through a REST API. This would remove the need for cloud functions as a middle layer.
On-premises databases can be tricky from a security perspective. Especially if you’re exposing an on-premises database to a cloud service. IT departments usually aren’t comfortable exposing internal ports to the outside world. There are two options:
- Install Losant on-premises or in your own cloud environment. Losant is a portable solution and can be installed in nearly any environment. This ensures the connection between Losant and your database is as secure as possible.
- Whitelist Losant’s outbound IP addresses. This provides a slightly more secure approach to exposing internal ports to the cloud. This ensures traffic can only come from Losant’s servers, however since Losant is a multitenant platform, technically it exposes your database to all Losant customers. They wouldn’t know your database’s credentials, but the fact that the database can be reached at all is sometimes an issue for IT.