topic Re: What are the best practices for MSSQL(Microsoft SQL Server )connection in Talend? in Talend Studio

What are the best practices for MSSQL(Microsoft SQL Server )connection in Talend?

Anonymous — Tue, 24 Apr 2018 10:15:42 GMT

Hi Team,

I wanted to know best practices to be used for creating MSSQL connection in Talend, as I don't know best practices

we have 3 DB in MSSQL server which is used as the source, target, and log DB and for every connection, we have created Joblet which we use in the job where it is required and then in MSSQLinput or Output component we use existing connection setting.

Just wanted to know if this is a good practice?

Attaching pic for reference

Thanks

Re: What are the best practices for MSSQL(Microsoft SQL Server )connection in Talend?

Anonymous — Tue, 24 Apr 2018 20:09:02 GMT

Hi Please any one can reply?

Re: What are the best practices for MSSQL(Microsoft SQL Server )connection in Talend?

Anonymous — Sun, 29 Apr 2018 17:05:33 GMT

no it still didn't received reply

Re: What are the best practices for MSSQL(Microsoft SQL Server )connection in Talend?

Anonymous — Mon, 30 Apr 2018 14:26:14 GMT

I think the way you are doing it is just fine. I personally don't have a lot of use case where there is the same DB used across many jobs like that. We use a lot of different DBs, especially when it comes to MSSQL. But usually if you are standardizing a code portion you would have to include in many jobs, joblet is the way to go.

Re: What are the best practices for MSSQL(Microsoft SQL Server )connection in Talend?

mks02 — Fri, 04 May 2018 10:02:32 GMT

Its depend upon your project structure and the procedure you are following for managing connection and logs for the operations. Using 3 DBs you can follow any of the approach:

-- One for Src, one for tgt and one for logdb
-- One for Src, One for Stage and one for tgt and logs
And many others approaches.

Just make to create joblets for different purposes (opening connection, data push to log tables after completion of job, closing connection).

These are the standard procedures to follow, and I think most of the projects are following these.

Re: What are the best practices for MSSQL(Microsoft SQL Server )connection in Talend?

mks02 — Fri, 04 May 2018 10:03:47 GMT

Hi,