I need to pump data into my Interbase database from many different sources (lets say from MySQL and from set of dBase tables) – how can I do that?
A. All you need to do is to setup separate profile for each data source (in your case one for MySQl and other from dBase files) and then pump data from them. Q. Let’s say, we have following tables at the target database: Table1: DEPARTMENT (ID, NAME) Table2: EMPLOYEE (ID, DEPARTMENT_ID, NAME, SURNAME) foreign key: DEPARTMENT.ID <=> EMPLOYEE.DEPARTMENT_ID The source database looks as follows: Table1: EMPLOYEE (ID, DEPARTMENT_NAME, NAME, SURNAME) Will be possible to efficiently import the data without creating auxiliary tables or columns? A. Yes – this is possible, please see next step by step instructions Step 1: Create custom SQL source DEPARTMENT_NAM — Custom SQL – source — select DEPARTMENT_NAME from EMPLOYEE group by EPARTMENT_NAME — This will get list of all department names from destination database Step 2: Create custom SQL destination INS_DEPARTMENT — Custom SQL – destination — INSERT INTO DEPARTMENT (ID, NAME) VALUES (GEN_ID(MY_GEN, 1), :NAME) — We assuming that you
