Advice around Staging Databases for Intgration

n999 — Sat, 16 Nov 2024 08:23:28 GMT

Hello

A quick question around integration architecture as we start our Talend journey.

Our migration architecture involves use of a staging database for ingestion, cleansing and transformation.

We are thinking what database requirements we would need for integration.

For routes we are hoping to use message queues for storing data.

If we need to build ELT or ETL jobs we imagine we will need some db staging area?

We were wondering if it is recommended to use the mysql db that comes with talend for this?

Thanks

Re: Advice around Staging Databases for Intgration

manodwhb — Wed, 18 Apr 2018 10:37:12 GMT

@n999,since you can use mysql db ,that the Talend can able to connect the msql db.