Database

​

Overview

The Database package provides pre-configured examples for building integrations that interact with database systems. These examples show how Alumio can retrieve data from a database, process and transform it, and write it back to a database using Incoming configurations, Outgoing configurations, and Transformers. The package helps you quickly set up database integrations by providing reusable templates for common database operations. You can use these examples as a starting point and customize them based on your database structure, queries, and integration requirements.

​

General Information

The Database package shows how different Alumio components work together in a database integration flow:

• Incoming configuration: retrieves data from a database using a database subscriber.
• Transformer: processes, normalizes, or restructures database records before sending them to another system.
• Outgoing configuration: writes processed data into a database using a database publisher.

These examples can be used to connect Alumio with various database systems and automate data exchange between databases and external applications.

​

Package Contents

The package includes the following example configurations: 1. Create a Database Generic Subscriber
Shows how to retrieve data from a database using a generic Database subscriber. Can be used to execute database queries and import records into Alumio for further processing. Common use cases include:

• Importing records from existing database tables.
• Synchronizing database data with external systems.
• Creating scheduled data extraction processes.

2. Create a Database Generic Publisher
Shows how to write processed data into a database using a generic Database publisher. Demonstrates how Alumio can export transformed data and store it in a target database. Common use cases include:

• Updating database records from external systems.
• Creating new records in database tables.
• Synchronizing data between multiple systems.

3. Create a Database Generic Transformer
Shows how to transform and prepare database data before it is published or sent to another system. Helps convert raw database records into the required data structure. Common use cases include:

• Renaming or mapping fields.
• Formatting database values.
• Removing unnecessary data.
• Preparing data for the target system.

​

Typical Use Cases

The Database package can be used for various integration scenarios, including:

• Synchronizing data between databases and external applications.
• Migrating data from one database system to another.
• Importing records from legacy database systems.
• Exporting processed integration data into database tables.
• Automating scheduled database data synchronization.

​

Customization

These configurations are designed as reusable templates. After importing the package, you can customize:

• Database connection settings.
• SQL queries or database operations.
• Table structures and field mappings.
• Transformers and data processing rules.
• Routes and scheduling settings.

This allows you to adapt the examples to your own database integration requirements while following Alumio’s recommended integration approach.

​

Integration Flow Example

A typical Database integration flow works as follows:

1. Incoming configuration retrieves data from the source database.
2. Transformer processes and converts the data into the required format.
3. Outgoing configuration sends or stores the processed data in the target database.
4. Route connects all components and manages the data flow between them.

Using these templates, you can quickly create reliable database integrations without building every configuration from scratch.

​

Template Import

Follow these steps to import a template to Alumio:

1. Log in to your Alumio dashboard.
2. Navigate to More > System > Import/Export

3. Click to browse or drag and drop ndjson file to upload it.

4. Click Import Configurations to start the import.