cancel
Showing results for 
Search instead for 
Did you mean: 

Replication solution with support for IQ as a source and target

kc-676583
Explorer
0 Kudos

Hi IQ Experts, 

 

We are looking for a solution to help us share data between our IQ database and other non-IQ databases via replication or CDC. The solution would need to support IQ as a source and target and support the most common cloud databases (for example Snowflake) and on-premise databases as a source and target.

What we are finding is that there is limited support for IQ connectors and where there is an IQ connector available it is a source only. 

Are there any tools or solutions the community could suggest we could investigate?

Many thanks,

KC

View Entire Topic
RobertWaywell
Product and Topic Expert
Product and Topic Expert
0 Kudos

SAP IQ is not generally used as a source database in replication architectures, in large part because it is an OLAP database rather than an OLTP database. SAP IQ is commonly used as a target in replication architectures with SAP ASE as the OLTP source database where transactional data originates and is then replicated to SAP IQ using SAP Rep Server. SAP IQ then serves as the reporting system. 

kc-676583
Explorer
0 Kudos
Thank you Robert