Database Connections & Inputs - Best Practices

PaulyWally — Wed, 01 Mar 2017 15:03:07 GMT

I have a Job that needs to read 12 different tables from the same MSSQL database.

Is it better to use 1 tMSSqlConnection and set all 12 tMSSqlInput to "Use Existing Connection"? Or is it better to keep the database parameters local to each tMSSqlInput?

Thank you in advance!

Re: Database Connections & Inputs - Best Practices

vapukov — Thu, 02 Mar 2017 02:40:47 GMT

it depend from You Job logic
generally more easy define single connection and close it after finish Job
with single connection You are as well can enable auto commit or use manual/rollback commit when it needed
but at the same time - all Your tables must be in same database(schema)

without single connection:
You can manage commit windows (commit every XXX rows)
You can have separate Database(schema) for each Input component

From information point of view:
if You use context variables instead of hardcoded details - change any information will be same, in single place only

topic Database Connections & Inputs - Best Practices in Talend Studio

Database Connections & Inputs - Best Practices

Re: Database Connections & Inputs - Best Practices