Copy Data from Firebird to a BDE-compatible database Automatically

1. Launch Advanced ETL Processor

• Create a Firebird/InterBase Connection using the database file path, host, username, and password
• Create a BDE Connection using the required alias, driver, and login details

2. Create a New Transformation

Right-click a transformation group and select New to create the copy workflow.

3. Configure Reader

• Double-click the reader component to open Reader Properties
• Select your Firebird connection
• Choose a source table or enter a custom SQL SELECT query

4. Configure Writer

• Double-click the writer component to open Writer Properties
• Select the BDE connection
• Choose the destination table or file
• Set the write mode: append, replace, or truncate

5. Map and Format Fields

• Map Firebird columns to BDE fields
• Check text encoding, numeric precision, and date formats
• Apply validation rules before writing records

6. Run the Transformation

Click the Run button (Green Arrow). Advanced ETL Processor writes the selected Firebird data into the BDE target and records the result in the execution log.