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)