Hello, I have 2 databases. They are le same tables, same name and structure. But in the second database for each table, I add 2 columns (ID autoinc, DB_NAME) I would like to create a job wich take the all table of the first DB (automatically) and insert data in the same table of my second DB and add in the column DB_NAME, a constant (for example : "DATABASE_1") But I don't know how I can do 😕 Can you help me please ??? Sorry for my english 😕
In Talend Exchange exists a component which is designed for the task to synchronize database.
In case of MySQL use this:
http://www.talendforge.org/exchange/index.php?eid=554&product=tos&action=view&nav=1,1,1 This component does not care about slightly different schemas. Only the columns which exists in the source and target will be transferred. It is not necessary to know the schema and this component can transfer the data in ETL mode: means over the network with different database connections.
I want to transfer data from an oracle (source) database to a postgresql (destination) database. I created a table on the destination postgresql database to mirror the source table. However, the schemas are different, for example the oracle table uses the db type "number" for an integer column, while the destination posgresql table uses the db type "Integer' (Int4). Talend creates schemas with the type "bigdecimal" for the oracle db type "number" and it creates the type "int/integer" for the postgresql db type "Int4". I've tried to manually define the schema so the types match, but I am not so sure I'm doing it correctly as it gives an error: ERROR: column "<comlumnname> " of relation "<tablename>" does not existException in component tPostgresqlOutput_1. But the column exists with the correct name just that I tried changing the type and db type to match the source, if I dont do that I get an error on the tPostgresqlOutput_1 component that the input row# type does not match
