With newer version of OE, Pro2 utilizes CDC to speed up replication. OpenEdge 11.7 is supposed to have support for Java UDFs but it has not been verified or tested. Management server also contains tools to generate SQL schema updates, new triggers if Source schema changes, etc.ĬDC by itself allows you to track changed records but the rest is your responsibility: creating schema for target, generating SQL loads, etc. I am aware of Pro2SQL for MS SQL target and Pro2Oracle for Oracle DBA.ĮDIT: did not read the question in full: your best option is to ask Progress itself, but I don't see why not: your agent will be just another user connecting to database, so if you have enough user licences, you should be fine.Įdit#2: on older versions of OE Pro2 uses older solution to track changes: it installs triggers for tables you want to replicate, they fire up and record change in auxhillary database, then replication agent ran on Management Server actually replicate records to Target.
The platform provides a high-performing, reliable database and offers a number of tools, including a rules engine, workflow processes, and analytics, among others. See : OBIEE 11g: How To Obtain Updated ODBC Drivers (Doc ID 1542558.1). Progress® OpenEdge® is an application development environment that simplifies the development and delivery of mission-critical business applications. 1) if you are on OE11.7 and later, you can use OpenEdge Change Data Capture to track data and replicate it Ģ) if you are on older version, you might use Pro2 software. Our OpenLink Single-Tier Drivers for Progress 4GL (SQL-89) are a Type-A class of driver developed using the Progress ESQL/C call-level interface they assume the prior installation of the. Protocol Progress OpenEdge Wire ProtocolDataDirect 7.1 Progress OpenEdge.
0 kommentar(er)
