External databases

Owned by Jeff Slavin (Unlicensed)
Last updated: Nov 19, 2024 by Aaron Allsbrook
2 min read

External databases allow developers to integrate different database types with their IoT Platform application. You should recreate and access your external database connections using the new API (collection connections 9.0.0 version). Any new external databases created must use the new ClearBlade.Database interface only. Connect collections created before the 9.0.0 version are external databases and can use the ClearBlade.Collection and ClearBlade.Database library interface.

Please create a support ticket to request integrations.

Adding an external database

Click + Add External Database, and a modal should appear. Enter the information from the database that you will be using. Not all database types will have the same settings fields. The standard settings fields for all database types are Database Name, IP Address, Port, Username, and Password. Oracle, DB2_Linux, DB2_zOS, DB2_System_i, and Cassandra are currently only supported in on-premise installations.

Google BigQuery example

 

 

MongoDB example

Permissions are needed to execute operations in the external database terminal.

Viewing the terminal

A terminal is available for your database commands and to execute operations against the connection. Results can be shown side-by-side with a JSON viewer when the Show JSON? box is checked.

Deleting the external database

Delete External Database can be found under the terminal. Click Confirm in the modal.