How I can define common "table names" in changeCaptureMySql processor configuration when 2 source database has same tableName and columns and destination DB have different tableNames

AbhishekSingh — Fri, 08 Jul 2022 13:11:41 GMT

Hi ,

I am trying to automate data from 2 source DB to one destination DB where some the tables name of source DB is same but in destination DB I have given table name as soursceDBName_tableName.

QA1-> How I can define common "table names" in changeCaptureMySql processor configuration when 2 source database has same tableName and columns and destination DB have different tableNames ?

QA2-> Also how i can identify these tables that which data source it comes to save in right table in destination DB

Ex. subscription DB(sourceDb1) -> status(tableName)

userOrg DB(sourceDb2) -> stats(tableName)

reportDb (destinationDB) -> subscription_status(TableName), userOrg(TableName).

Please refer the screenshot for same.

Re: How I can define common "table names" in changeCaptureMySql processor configuration when 2 source database has same tableName and columns and destination DB have different tableNames

AbhishekSingh — Mon, 11 Jul 2022 15:36:19 GMT

I have got solution for this.

question How I can define common "table names" in changeCaptureMySql processor configuration when 2 source database has same tableName and columns and destination DB have different tableNames in Support Questions

How I can define common "table names" in changeCaptureMySql processor configuration when 2 source database has same tableName and columns and destination DB have different tableNames

Re: How I can define common "table names" in changeCaptureMySql processor configuration when 2 source database has same tableName and columns and destination DB have different tableNames