AdvancedDELMIAworks (formerly IQMS)Integration / Database

IQMS ERP API: DELMIAworks Integration Options Compared

Question
iqms erp api

Also searched as

  • delmiaworks manufacturing erp formerly iqms
  • iqms oracle database access
  • iqms integration options

Short answer

IQMS was renamed DELMIAworks after Dassault Systemes acquired it, so searches for the IQMS ERP API lead to the DELMIAworks integration options: a web API, read-only access to the Oracle database, import and export utilities, EDI, and middleware. The right option depends on whether you read, write or both, and on how much upgrade risk you accept.

Applies to: IQMS and DELMIAworks releases. Older IQMS versions have fewer API options; check your version with the vendor.

Choose the integration route

  1. 1Confirm your version and whether it is called IQMS or DELMIAworks in your contract.
  2. 2List the use cases: reporting, shop floor data, quality, eCommerce, EDI, CAD or PLM.
  3. 3For reading data at scale, use a read-only database account on a replica.
  4. 4For transactional exchange, use the vendor web API or supported import routes.
  5. 5For partners, use EDI or a middleware product that already supports the system.
  6. 6Test everything in a non-production instance.
  7. 7Plan for retesting at each upgrade.

The history in one paragraph

IQMS was a manufacturing ERP built on an Oracle database, widely used in plastics and discrete manufacturing. It became DELMIAworks under Dassault Systemes, which also owns SolidWorks, so integration with design tools is a vendor theme. Old documentation and forum posts use the IQMS name; new ones use DELMIAworks.

Route 1: web API

The web API is the cleanest route for operational integration because it goes through business logic. Obtain documentation and licence terms from the vendor, use a dedicated credential, and design for retries.

Route 2: database access

Because the system sits on Oracle, analytics and AI tools often connect read-only through ODBC or JDBC. This is quick and powerful, but table names and relationships are not a stable public contract, so use views you control and test after upgrades. Do not write to tables directly.

-- Example pattern: create a read-only reporting user (adapt names to your site)
CREATE USER reporting_ro IDENTIFIED BY "change_me";
GRANT CREATE SESSION TO reporting_ro;
GRANT SELECT ON <schema>.<approved_view> TO reporting_ro;

Route 3: imports, EDI and middleware

For customer and supplier exchange, EDI is the standard route, and middleware vendors often have connectors. Import and export utilities fit one-off or batch loads such as items or price lists.

Try it here, free

DELMIAworks (IQMS) Private AI Layer Blueprint Generator

Open full tool

Fill in your version, database, hosting and use cases to get an architecture plan for a private, on-prem AI assistant on DELMIAworks (IQMS), ready to share with IT and security.

Common pitfalls

  • !Searching only for IQMS documentation and missing newer DELMIAworks material.
  • !Hard-coding table names into integrations without a view layer.
  • !Writing directly to Oracle tables.
  • !Giving the integration a DBA-level account.

How an ERP-grounded AI assistant handles this

Because the data sits in a relational database, a private AI layer can answer questions against read-only views, explain results, and show the SQL. Netray builds this on-prem with open-weight models so no ERP data leaves the plant network.

See ERPray

Frequently asked questions

Is IQMS the same as DELMIAworks?

Yes. IQMS was renamed DELMIAworks after the product moved to Dassault Systemes, so older IQMS material often still applies with updates.

Is there an IQMS API?

Newer releases offer a web API, and sites also integrate through the database, imports, EDI and middleware. Confirm what your version supports with the vendor.

Is read-only SQL access safe?

Yes if you use a restricted account on a replica or approved views. Writing directly is what causes data integrity and upgrade problems.

Related

How-to

DELMIAworks Web API: How to Integrate and Where to Get Support

DELMIAworks offers a web-based API for integration, and the technical documentation sits behind the customer support portal for licensed customers, so confirm access and licensing with your account team first. Alongside it, many sites integrate through the Oracle database, import and export utilities, and middleware. Pick the route by direction of data and risk.

How-to

DELMIAworks with SolidWorks, SPC and Shop-Floor Add-ons

To get a SolidWorks bill of materials into DELMIAworks, export the BOM with item numbers that match the ERP item master, stage it, validate it, and load it through a supported import or the web API. SPC and shop-floor add-ons connect through the same pattern: define the data, the owner of each field, and a validation step. Confirm product specifics with the vendor.

Advanced

How to Add a Private AI Layer to DELMIAworks (IQMS) On-Prem

DELMIAworks, formerly IQMS EnterpriseIQ, runs on an Oracle database that you can read through a standby or replicated copy. A private AI layer queries well-known tables such as ARINVT for items, indexes documents locally, serves an open-weight model on your own GPUs, and writes back only through the vendor's supported interfaces after a person approves.

AI for ERP

AI for DELMIAworks (IQMS), grounded in your production monitoring data

Add private, on-prem AI to DELMIAworks (IQMS): query production monitoring data, triage scrap, and draft CAPA reports in plain language. See how it fits your plant.

Stuck on DELMIAworks (formerly IQMS)?

Talk to engineers who work inside DELMIAworks (formerly IQMS) every week, and who build private AI that answers these questions from your own ERP data.

Talk to an ERP engineerBrowse ERP Help
All ERP Help articles

Keep exploring

Free tools

ERP fixes and how-tos

Guides

AI on your ERP

Integrations

Software