Configuring ETL Users permissions in ITA

[wesburhoe]

Seeking input and guidance... regarding how ITA manages the ETL databases (we run ours internal) serving our external integrations. Folks familiar with the ITA GUI to create ETL jobs know that you cannot re-use the same "etluser_name" for multiple configurations. 

As you create multiple ETL jobs on your ITA... there comes a need, to be able to configure one of the accounts created to have full access to all the others. So far (not being a DBA) i have found the settings are kept here 

/etc/isx-operations/postgresql/pg.hba.conf

What I have noticed, any changes made to this file are wiped out when we reboot the host... or add a new ETL job. What I need to know is how/where we make the neccessary changes to ensure our additional permissions are never removed?

[gsterling]

Hello Wes, I will follow-up with you with a direct email.

Regards

Greg Sterling

[wesburhoe]

Closing the loop on this post... If making custom edits to the postgres user accounts, to ensure changes stick around after reboot or when new ETL jobs are added, add the needed changes to the template file which sits in the same directory.

/etc/isx-operations/postgresql/pg.hba.conf.template

Although I will also add... the driver behind this request was to streamline a stored procedure. Turns out we were able to leverage the default accounts. Altering permissions was not required. To do this, we enabled the DB extension "dblink" and got it all working. 

Fun stuff!
😃