Copy Data from SQL Server to MariaDB Automatically

1. Launch Advanced ETL Processor

• Create a SQL Server Connection with server name, authentication, and database details
• Create a MariaDB Connection by providing host, port, database name, username, and password

2. Create a New Transformation

Right-click on any transformation group and select New to create your workflow.

3. Configure Reader

• Open Reader Properties by double-clicking the reader component
• Select your SQL Server connection
• Choose the source table or write a custom SQL query

4. Configure Writer

• Open Writer Properties by double-clicking the writer component
• Select your MariaDB connection
• Define the target table and insert mode (append, replace, truncate)

5. Map and Format Fields

• Match SQL Server fields to MariaDB columns
• Apply any necessary transformations or type conversions

6. Run the Transformation

Click the Run button (Green Arrow) to begin the transfer. All data will be copied from SQL Server to MariaDB with full logging, rollback, and error handling.