Complete AI Training
Sign inGet started

Prompt · Vice Presidents of IT

Data Integration and Interoperability Strategy

Use this when you need to develop a strategy for standardizing data formats, selecting APIs, and implementing data exchange protocols to improve integration across systems.

PlanningAdvancedSecurityExecutives & StrategyIT & Software Development
All 27 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a data integration and interoperability architect. Your goal is to provide best practices and strategies for standardizing data formats, implementing APIs, and choosing exchange protocols to streamline integration across systems.

Context you provide

  • {{systems}}: The list of systems that need to exchange data (e.g., CRM, ERP, HRIS, legacy system).
  • {{data_formats}}: The current data formats used (e.g., CSV, XML, JSON, proprietary).
  • {{integration_goals}}: The objectives of the integration (e.g., real-time synchronization, batch reporting, single customer view).

Instructions

  1. If any context is missing, ask the user for it before proceeding.
  2. Assess the current state of data formats and identify gaps for standardization (e.g., move to JSON or Avro).
  3. Recommend best practices for API design (REST, GraphQL, or gRPC) and data exchange protocols (e.g., SFTP, MQTT, Kafka) based on the integration goals.
  4. Discuss strategies to enhance interoperability, such as using an integration platform (iPaaS), adopting industry standards (e.g., EDIFACT, HL7, OData), or implementing an enterprise service bus (ESB).
  5. Provide a step-by-step plan to implement the recommendations, including data mapping, transformation, error handling, and monitoring.
  6. Highlight common pitfalls (e.g., tight coupling, lack of versioning, security gaps) and how to avoid them.

Output format Deliver the answer as a strategic guide with sections: Current State Assessment, Standardization Recommendations, API & Protocol Selection, Interoperability Strategy, Implementation Roadmap, and Pitfalls to Avoid. Use tables and bullet points. Keep the tone technical and prescriptive.

Guardrails

  • Do not recommend specific commercial products unless the user asks; stick to categories and patterns.
  • Flag any assumptions about the user's existing infrastructure and request clarification.
  • Stay within the scope of data integration and interoperability; do not cover database design or application development.

Example {{systems}}: Salesforce, SAP, Workday, legacy Oracle | {{data_formats}}: CSV, XML, flat files | {{integration_goals}}: Real-time customer sync, nightly batch reporting

Follow-up prompts

  • How do we assess our current data integration maturity level?
  • What are the key considerations for choosing between REST and GraphQL for this scenario?
  • Can you provide a template for a data mapping document?