Skip to content

Datapump

Datapumps are scheduled to run using task scheduler. Each pump takes connections to two databases. Source is each customers live database. Destination is Datapump database depending on which pump it is. From pumped data customer creates reports.

  • Ahola has 3 different datapumps running

DatapumpKPI = Live, running every 15min

DatapumpOCL = Nightly, running on every night, starts about 23.30

DatapumpPipedrive = Daily, running 06.50 and updates contacts

Source database = (GCP) mssql-stable:Ahola_AO_Live Destination database = (on-prem) sql2k17cluster.attracs.com:Datapump / DatapumpPlanKPI / datapumppipedrive

Datapump exes are running in Datapump server (10.170.0.54). Datapump server hosts also these: * User Profile Disks (RDS-profiles, used in RDS-collections) * Licensing Server (for whole env. users cal-licenses)


Subpages