Copy Data from SQL Server to a BDE-compatible database Automatically

1. Launch Advanced ETL Processor

• Create a SQL Server Connection with server name, instance, authentication, and target database
• Create a BDE Connection by specifying the BDE alias or direct table path

2. Create a New Transformation

Right-click on a transformation group and choose New to build your data workflow.

3. Configure Reader

• Double-click the reader component to open Reader Properties
• Select the SQL Server connection
• Choose a table or write a custom SQL SELECT query

4. Configure Writer

• Double-click the writer component to open Writer Properties
• Select the BDE connection
• Choose the target table and insert mode (append, replace, truncate)

5. Map and Format Fields

• Map SQL Server fields to BDE target columns
• Apply type conversion or transformations if needed

6. Run the Transformation

Click the Run button (Green Arrow). The data will be copied from SQL Server to BDE with rollback, logging, and error handling options enabled.