Overview
AI Magic in eZintegrations enables users to transform, structure, and deliver data to any supported database using simple English prompts. Instead of building complex integration pipelines, users can define data processing logic in natural language. The system automatically prepares structured output suitable for direct database insertion or updates.
This feature simplifies data workflows by allowing users to extract, format, group, and prepare data from multiple sources, including APIs, emails, WebSockets, and databases, using a single intelligent prompt.
The Magic: From Data Jumble to Smooth Delivery
Data often arrives in unstructured or fragmented formats, such as API responses, email content, streaming feeds, or database records. AI Magic replaces multiple manual transformation steps with a unified prompt-driven process.
By describing the required transformation in plain English and referencing key fields, the system automatically restructures the data and prepares it for database delivery. This reduces configuration complexity and eliminates the need for advanced scripting.
When to Use
AI Magic is designed for scenarios where data must be transformed and loaded into databases with minimal manual processing.
- When integrating API, email, or streaming data into databases
- When rapid setup is required without custom coding
- When data structure changes frequently
- When standard mapping rules are insufficient
- When business users need low-code or no-code automation
Quick Setup: Connect Anything, Anywhere
Source Side Configuration
On the source side, users select the origin of their data and extract relevant fields.
- Select source type: Email, API, WebSocket, or Database
- Configure connection parameters
- Extract required fields
- Preview extracted data in the Test Section
Example extracted data:
{
"item": "gadget",
"qty": 5,
"client": "shopper@example.com"
}
Target Side Configuration
On the target side, users configure the destination database and define how data should be inserted or updated.
- Select “Database” as target
- Enter host, port, database name, and credentials
- Select destination table
- Define insert or update queries
- Map fields if required
The system automatically adapts to configuration changes without additional adjustments.
Supported Databases: Source and Target
eZintegrations supports multiple enterprise-grade databases for both source and target connections.
| Database |
|---|
| Amazon Aurora (MySQL/MariaDB) |
| Amazon Aurora (PostgreSQL) |
| Amazon Redshift |
| Microsoft SQL Server |
| MySQL/MariaDB |
| Oracle Database |
| PostgreSQL |
| Snowflake |
| SQLite |
| Teradata DB |
Users may also connect custom databases as sources or targets.
How It Works
AI Magic processes natural language instructions and converts them into structured data transformation logic.
- Reads input data from configured sources
- Identifies referenced fields
- Applies transformation rules from prompts
- Generates structured JSON output
- Prepares data for database insertion
This automated pipeline removes the need for manual data parsing or scripting.
The Core: AI Prompt, Everyday Words Make It Happen
The core feature is the AI prompt interface, where users describe required transformations using natural language.
The prompt references existing fields and defines how data should be grouped, enhanced, and formatted.
Real Example We Tested
{
"page": 1,
"per_page": 1,
"total": 1,
"total_pages": 1,
"data": [
{
"id": 101,
"email": "alex.smith@example.com",
"first_name": "Alex",
"last_name": "Smith",
"avatar": "https://example.com/images/alex.jpg"
}
],
"support": {
"url": "https://contentcaddy.io?utm_source=example&utm_medium=json&utm_campaign=referral",
"text": "Create content effortlessly with Content Caddy."
}
}
Sample Prompt
Extract the data array from {%bizdata_dataset_response%} as individual records.
Add a new field 'export_flag_y': 'Y' to each record.
Group records by 'export_flag_y' and store in a new array called 'orderLines'.
Convert 'orderLines' into a list of tuples (id, email, first_name, last_name, avatar).
Return the result under the key 'tabledata' in JSON format.
Generated Output
{
"tabledata": [
[101, "alex.smith@example.com", "Alex", "Smith", "https://example.com/images/alex.jpg"]
]
}
This output is immediately usable for database operations.
How to Configure
To configure AI Magic for database delivery:
- Create an integration flow
- Configure source connection
- Configure database target
- Enable AI Magic processing
- Enter transformation prompt
- Test and preview output
- Deploy the workflow
Users may modify prompts to handle additional conditions, such as filtering incomplete records.
Troubleshooting
- Invalid Output Format: Review prompt syntax and field references.
- Missing Fields: Verify source extraction settings.
- Database Errors: Confirm credentials and table schema.
- Unexpected Data: Enable logging to review transformed output.
Frequently Asked Questions
What is AI Magic in eZintegrations?
AI Magic is a natural language-based data transformation feature that converts unstructured or semi-structured data into database-ready formats.
Do I need programming knowledge to use AI Magic?
No. AI Magic uses plain English prompts and does not require scripting or coding skills.
Can AI Magic handle changing data structures?
Yes. Prompts can be adjusted to accommodate changes in incoming data formats.
Is the output suitable for direct database insertion?
Yes. The generated JSON output is structured for immediate use in database queries.
Which databases are supported?
AI Magic supports multiple databases including MySQL, PostgreSQL, SQL Server, Snowflake, Oracle, and others.
Notes
- Scheduled execution can be configured using cron expressions.
- Live logs are available for monitoring executions.
- Prompts should reference valid source fields.
- Preview output before deploying to production.
Begin your data journey at eZintegrations, where simple words enable reliable and scalable data automation.
For more information, visit: https://help.bizdata360.com/link/234#bkmrk-begin-your-data-jour
