Databases from Databases
Summary
The Databases connector offers all the capabilities needed to connect to such sources. This option allows you to collect data from different types of databases or configure writing actions, then create data views and exhibit them in your API.
To connect you must go to Data Sources > Databases
Basic concepts
Operations
The platform would allow you to create sources from the database according to each CRUD operation (Create, Read, Update, Delete) it requires.
Supported databases
The platform currently supports the following databases and versions. If your database is not listed, please contact support.
Endpoint or connection string
To connect to a database you should know the endpoint or connection string, formed by the following structure:
{{server}}:{{port}}/{{{nameData
Connection properties
Connection properties allow you to control various configurations in database connections. You can review the documentation of the connection properties for each database if you need to customize its properties.
Authentication schemes
Configure connection
The basic concepts described above were intended to understand how it may be required to set up a connection to a database on the platform.
It would now explain how to set up such sources.
The configuration can be divided into the request to the database and in the processing of its response.
Request
In order to set up the application for service you should consider the following aspects. Once the setup has been made, you should click on the Test button to make the request.
Operation
You should indicate the method or type of operation: Reading, Writing, Updating or Deleting.
Endpoint
You should enter the endpoint or URI of the server where the database is located, without indicating the protocol.
A technical structure is as follows, where the server can be an IP address or domain.
{{server}}:{{port}}/{{{nameData
Authentication
In the Authentication tab you must enter user and password of the database.
If you require other authentication, please contact support.
Pool of connections
A pool of connections is a limited set of connections to a database, which is handled by an application server, in a form that such connections can be reused by different users to increase efficiency. The management of a pool favors the scalability and performance of an application.
You can set up the number of initial connections, the maximum number of active connections and standby connections.
Connection properties
Connection properties allow you to specify connection settings to the database. Some databases have predefined connection properties, but you can modify them or add new properties.
Review the documentation of connection properties based on the type of database you were using.
List of tables
By completing the configuration of the connection, you could test the connection to the database. If the connection is successful, the list of tables in the database would be displayed and the query statement could continue to be entered.
Judgment or consultation
Depending on the type of CRUD operation you have selected, you could enter the judgment or consult the database.
In the content of the statement you can add mapping and then set them as parameters of your API method.
For example, this is a typical case of the use of mapping:
SELECT * from users WHERE accountId = {{accountId}} ORDER BY created {{order}}
{{accountId}} and {{order}} are the mapping names and parameters that would be displayed in the data view and API method.
Answer
Once the judgment has been entered, it could execute it using the Preview button.
To process the answer you can select whether or not to include titles or headers.
So far it has configured its data source from the web service. You should now create a data view to continue the process.
Related Articles
What is a data view
Summary The platform does not require an off-line ETL process to extract data from the origins, but associated with the view, find a set of rules that the data engine interprets for check the source on demand or periodically, extract the data updated ...Data sources from URLs
Summary The URL connector allows you to collect data from HTTP(s) and FTP protocols. To collect data from a file hosted in a URL, you must go to Data sources > From URLs Configuration Enter a URL with a clear link from where you want to collect. ...Data sources from REST/json web services
Summary The REST/JSON web services connector offers all the capabilities needed to connect to such sources. This option allows you to collect data from REST/JSON web services or configure writing actions, and then create data views and exhibit them ...Select data and headers
Summary Data views allow you to select the data and define the headers or titles that would be available in APIs methods. It is possible to make selections from the entire table, columns, column intersections and rows. In addition, it is possible to ...What are data sources
Summary Data sources are the starting point for the data flow, from which data views and APIs methods are created. Below you can find data sources characteristics. Some basic concepts When we talk about data sources, we must consider the following: ...