I wonder what functionalities ETL and data analyses tools have that allow to display the mapping of pre-defined inter-connections in contacts datas.
In my case, some profiles/companies are attached to a list or a group; or have required the addition of complementary notes in a sub-module, etc… I expect to have these inter-connections still implemented once loaded in the new CRM database.
- MY QUESTIONS *
Does KNIME have nodes that allows to map, edit and transform these inter-connections ?
What best match with this purpose (as a preparation of data migration) ?
• connection to source database
• file import (csv, sql, or xml) ?
Should such job be done (or not) to insure that these inter-connections will remains once the migration to the new database would have been executed ?
Please help, or let me know if something is not clear enough in this post !