Database Connection point

In this way, you can retrieve data from a database and send it to one or more Infor applications. Or you can use data from Infor BODs to update your database.

These types of database connection point exist:

• Stored Procedure
• AnySQL Modeler
• Data Loader

With Stored Procedure type you can call stored procedures that are defined in your database, pass inputs and receive output in form of Infor BODs.

With the AnySQL Modeler you can create SQL select statements to read data from database in visual modeler with minimum knowledge of SQL language. Learning specifics of each database protocol is not required. The same modeling experience is used for each of supported database server types. Output is provided in form of JSON document.

With the Data Loader type you can use Data Loader to load complete tables directly to Data Lake. The Data Loader type does not have any Documents tab, all configuration is done in Data Loader. It cannot be used as standalone connection point in data flows.

In a document flow, the use of database connection points is comparable to the use of any type of connection points. BOD or JSON documents from a database can be delivered to other supported connection points. Data in BODs from any connection point can be delivered to a database.

The definitions of a database connection point:

• The standard properties for any connection point, such as name, description and tenant. For database connection points the logical ID type is fixed ('database'). The logical Id is lid://infor.database followed by the converted name.
• Connection point type selection
• How to connect to the database.
• Which documents are sent and received and how the data must be read from the database for these documents.