Question : I’ve requirement where I need to store information from different sources in my system and the process that […]
Tag: integration
Looking for advice on how to integrate data from 100+ client DB’s into a centralized reporting database
Question : I am a SQL Developer (not DBA or Architect) for a small (~50 employees) SaaS company. I am […]
Looking for advice on how to integrate data from 100+ client DB’s into a centralized reporting database
Question : I am a SQL Developer (not DBA or Architect) for a small (~50 employees) SaaS company. I am […]
SQL User Permissions for Continuous Integration via DbUp and Octopus
Question : Currently, our deverloper group has started using DbUp and Octopus to do Continuous Integration on SQL Database Deployments. […]
decrypt data in column before load into destination
Question : I have a table named city which contains two columns city_id (int) city_name (varbinary) — encrypted column I […]
Scheduled snapshots of views (without using materialized views or Oracle Golden Gate)?
Question : I have 40 views in an Oracle 18c GIS database that are used in a map in a […]
SQL User Permissions for Continuous Integration via DbUp and Octopus
Question : Currently, our deverloper group has started using DbUp and Octopus to do Continuous Integration on SQL Database Deployments. […]
Not able to create SSISDB catalog
Question : Getting the error below while trying to create a catalog in sql server 2014 integration services. Any idea […]
Does MySQL have a version of Change Data Capture?
Question : We’re in the process of phasing out an old system and migrating onto a new one. The last […]