Data Replicator is an add-on to Invantive SQL which enables replication of data stored in cloud-based applications into a relational database such as SQL Server or PostgreSQL using techniques such as mirroring, trickle loading and sampling. Use this tag for questions about the use of Data Replicator and make sure to also add the appropriate tag for the system you are replicating, like exact-online or salesforce.
Questions tagged [data-replicator]
5 questions
1
vote
1 answer
Microservices Replication: What about the Database?
Let's say you are using either ServiceFabric or Kubernetes, and you are hosting a transaction data warehouse microservice (maybe a bad example, but suppose all it dose is a simple CQRS architecture consisting of Id of sender, receiver, date and the…
Alphas Supremum
- 435
- 3
- 17
1
vote
2 answers
Continuously replicate data from Oracle to ElasticSearch
Team where I'm working has a luck to work on redesigning huge legacy system, with Oracle 12 on database end. Currently this monster software has 10% of insert/update/delete operations in DB, rest 90% of operations are the select operations…
Viktor Fursov
- 123
- 1
- 8
1
vote
2 answers
How does pglogical-2 handle logical replication on same table while allowing it to be writeable on both databases?
Based on the above image, there are certain tables I want to be in the Internal Database (right hand side). The other tables I want to be replicated in the external database.
In reality there's only one set of values that SHOULD NOT be replicated…
Kim Stacks
- 10,202
- 35
- 151
- 282
1
vote
1 answer
Transferring data between two PostgreSQL servers
I have two PostgreSQL servers, one centralized, and one peripheral. The idea is for the peripheral server to accumulate data from various processes running on the same machine. Periodically (Maybe hourly, or thereabouts), the data is shipped from…
Jarmund
- 3,003
- 4
- 22
- 45
1
vote
1 answer
Automatically set logical view on Data Replicator table on Exact Online
I am using Invantive Data Hub with the Data Replicator option to replicate Exact Online in our Azure database. The tables with names such as: dcd_ganw2_wpbz0_djmwe are nicely created automatically and go away automatically. And column names like…
Gijs Croes
- 11
- 1