Upgrade of DataSourcer and ETL applications

[nishantank]

Hello

I am supposed to undertake an upgrade of DataSourcer & ETL Application from 7.1.000.06 to 7.2.100.48.
Are there any extra steps (like running some database scripts to update the corresponding databases) or is there a particular sequence to be followed for this?

FYI - The customer's DBMS is MSSQL Server and the contact centre closes at 19:00 so I plan to do the upgrade starting 19:30.

Regards
Nishant Tank

[borkokrz]

DataSourcer and ETL have "builted in" procedures of databases upgrade, which are run upon the first start of new versions. If you don't change configuration (like implement HA on DS) upgrade is quite simple and doesn't need anything on database level. Sequence -
stop DS,
stop ETL (after last chunk transfer),
backup *.properties files,
backup databases (optional),
upgrade&start&check DS (do not create new application in CME or you will have to update DBID of new DS in ODS database)
upgrade&start ETL in transformation-and-aggregation or transformation only modes (upgrade is done only in this modes),
start ETL.

[Pranpong.S]

totally agree with borkokrz. Make sure datasourcer & ETL service are stop.
One more thing , back up the datasourcer & etl folder then create the new one when install new version of both.
Just easy.
Pranpong

[nishantank]

Thanks Guys.
I have made a note of those details.

I plan to install the DS and ETL in different location so probably I can skip the step of backing up *.properties files?

Will update this thread with the result once this upgrade goes through ... probably tonight.

Once again - Thank You.