Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Router adds name mapping scripts #315

Open
zzl221000 opened this issue Jan 17, 2025 · 3 comments
Open

Router adds name mapping scripts #315

zzl221000 opened this issue Jan 17, 2025 · 3 comments
Labels
enhancement New feature or request

Comments

@zzl221000
Copy link

Motivations

Filters can use wildcards, but the specific tables being synchronized are variable, which can cause the table mapping feature to become ineffective.

  • Would you like to implement this feature? [N]

Solution

I think the best way is to use embedded scripts to handle mapping relationships, which is more flexible.

@zzl221000 zzl221000 added the enhancement New feature or request label Jan 17, 2025
@qianyiwen2019
Copy link
Collaborator

qianyiwen2019 commented Jan 20, 2025

I think db_map, tb_map,col_map , and even "etl by lua" can solve this issue ?

please refer to: https://github.com/apecloud/ape-dts/blob/main/docs/en/config.md#router
and : https://github.com/apecloud/ape-dts/blob/main/docs/en/tutorial/etl_by_lua.md

@zzl221000
Copy link
Author

zzl221000 commented Jan 20, 2025

I think db_map, tb_map,col_map , and even "etl by lua" can solve this issue ?

Does the tb_map function support pre_(.+): $1?
All tables need to have prefixes or suffixes removed.

It seems that Lua can solve this problem.
@qianyiwen2019
Edit: etl by lua does not seem to support mongodb

@qianyiwen2019
Copy link
Collaborator

qianyiwen2019 commented Jan 20, 2025

OK,I got your point, we will consider this after the Chinese new year.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants