How would you connect to an Oracle CRM system? Would you use IDMS?

Connecting to an Oracle CRM system can be done through several methods. The most common approach is using Oracle's REST or SOAP APIs, which expose CRM data over HTTP and can be consumed by any language. Alternatively, you can use JDBC or ODBC drivers to query the underlying Oracle database directly, though this requires careful handling of security and schema changes. If the CRM is part of an older mainframe environment, IDMS (Integrated Data Management System) might be used, but it is less common today. Modern integrations often employ middleware such as Oracle Integration Cloud, MuleSoft, or custom ETL pipelines that pull data via APIs, transform it, and load it into downstream systems. The choice depends on performance needs, security requirements, and whether you need real‑time or batch access.