Hello to all of you.
Our IT department uses OpendEdge 10.2b db and an ERP written with OE102B
We have also written a DW with SQL SERVER 2014 BI EDITION.
I read about PRO2-SQL product as a good software to customers who need to have only updated records from certain (not all) tables from ERP's DB.
We do not want to implement TRIGGERS inside our DB
I'd like idea to have a software to do custom replication , without changing ERP's structure...
Example:
We have a lot of SSIS package to pull data
We'd like to pull data we need , that is only updated records in a day ...
Our ERP do not match all updated records.
Our DW is being to be very large...and then also ssis packages' time execution.
Any advices ???
Regards in advance.
Our IT department uses OpendEdge 10.2b db and an ERP written with OE102B
We have also written a DW with SQL SERVER 2014 BI EDITION.
I read about PRO2-SQL product as a good software to customers who need to have only updated records from certain (not all) tables from ERP's DB.
We do not want to implement TRIGGERS inside our DB
I'd like idea to have a software to do custom replication , without changing ERP's structure...
Example:
We have a lot of SSIS package to pull data
We'd like to pull data we need , that is only updated records in a day ...
Our ERP do not match all updated records.
Our DW is being to be very large...and then also ssis packages' time execution.
Any advices ???
Regards in advance.