To use data from an external database inside your app, you first have to have configured a database connection and then configured your tables and/or written your custom queries. If you haven't yet please read more about this in these articles:
If you are done with those steps you might now start using your database connection. This may be done in two different ways. You might either use Visual Coding and leverage on the built in functions for database connections or you may manually consume the database connection service.
This article will cover how to use Visual Coding. For more information about manually using our API services please read more in these articles:
Using Visual Coding
The easiest way to consume data from an external database is to use the built in Visual Coding managers. These managers is found under the Cloud folder in the Visual Coding editor.
Cloud.DBC.Table.View
Lists the rows in a database table. Is only available for tables that have been configured with data mapping.
Cloud.DBC.Table.Insert
Inserts one new row in a database table.
Cloud.DBC.Table.Delete
Removes one or more row(s) from the database table.
Cloud.DBC.Table.Update
Updates one or more row(s) in a database table with more information.
Cloud.DBC.Query.Collection
Executes a custom query in your database. If the query has data mapping configured a collection of data objects will be returned if the query returns any data.
Cloud.DBC.Query.Object
Executes a custom query in your database. If the query has data mapping configured a data object of the first item returned by the query will be returned.
