Creating and Deleting Data Sources

• Create a data source
• View existing data sources
• Filter data sources with the search tool
• Edit data sources
• Delete data sources

Creating a new data source

To create a new data source, access the Data Sources screen and click + DATA SOURCE in the upper right corner of the screen. Then fill in the requested fields.

Creating a new data source takes place in 3 steps:

Recording basic database information

• Name: unique name that will identify the database. This name will appear in the list of available databases when creating the integration flow.

  • Limit of 100 characters.
  • Only alphanumeric characters, - or _ are allowed.
  • Space is not allowed.

• Description: database description. Limit of 1024 characters.

Configuring the driver

• Database Type: select the database to be configured.
• Driver: field loaded automatically according to the database selection. It is the file that contains the JDBC implementation for a specific database. Editing this field is not allowed.
• Version: select one of the available database versions. This field is only enabled after selecting a database.
• Driver Class: field loaded automatically according to the database selection. It is the full name of the Java class within the driver that Camel uses to initialize the connection to the database. Editing this field is not allowed.

Configuring the environment

To configure the environment, click the pencil icon on the right, in the Actions column. You can configure the same database for one or both available environments.

Basic properties

You must fill in the fields with your database access credentials. Then click CONFIRM.

• URL: connection URL
• User: username
• Password: access password

Advanced properties

The advanced properties of data sources allow more detailed control of the JDBC connection pool, as well as enabling specific adjustments to the connection behavior. This helps improve performance, increase resilience to network failures, and optimize costs.

IMPORTANT

Advanced properties are applied individually in each environment.

TIP

The advanced properties configuration fields display default values.

The table below describes the available advanced properties:

Connection Validation

NOTE

• The advanced properties configuration fields display default values.
• The maximum limit for each field is 15 numeric digits (Initial Size, Max Total, Max Idle, Min Idle, Max Wait Millis, and Validation Query Timeout).
• Negative values are not allowed, except in the maxTotal, maxWaitMillis, and maxIdle fields.

After completing this step, confirm the information.

TIP

Gray status indicates that the database is not configured in that environment. Green status indicates that the database is configured in the environment.

Viewing existing data sources

The Data Sources screen displays all created data sources. You can choose the display format in list or card format by clicking the respective icons in the upper right.

The image below shows existing data sources in list format:

The following information is available for viewing:

• Name: name used in the database registration.
• Description: database description.
• Database Type: type of database (Azure SQL, DB2, Firebird, etc.).
• Version: database version selected during registration.
• Environment: environment in which the database is configured, indicated by green color.
• Actions: click the pencil icon to edit a data source.

NOTE

The data source editing functionality will be available soon.

Filters

At the top of the screen, you can search for data sources using the following filters:

• Database Type: type of database (Azure, DB2, Firebird, etc.).
• Environment: Production and Staging.

To search for a specific data source, type the name or a word from the flow description in the search box and click SEARCH.

Editing a data source

To edit a data source, follow these steps:

NOTE

It is not possible to edit the database name in the Name field.

IMPORTANT

If you edit a data source linked to a deployed flow, the flow must be deployed again.

Deleting a data source

To delete a data source, follow these steps:

Alternatively, you can delete a data source by accessing its editing screen and clicking the trash icon in the upper right corner of the screen.

IMPORTANT

Data sources that are in use in integration flows cannot be deleted.