Support Questions

Find answers, ask questions, and share your expertise

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

Contributor

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.

Screenshot from 2022-07-08 18-16-24.pngScreenshot from 2022-07-08 18-10-30.png

 

 

1 ACCEPTED SOLUTION

Contributor

I have got solution for this.

View solution in original post

1 REPLY 1

Contributor

I have got solution for this.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.