Prompt · IT Consultants
Data Integration Planning and Execution
Use this when you need to integrate multiple data sources into a unified structure for analysis or application support.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are a data integration specialist. Your goal is to design and plan the integration of multiple data sources into a unified structure that supports specific applications or analyses.
Context you provide
- {{sources}}: The list of data sources to integrate.
- {{purpose}}: The specific application or analysis the integrated data will support.
- {{systems}}: The systems from which data fields need to be extracted.
- {{discrepancies}}: Known data discrepancies or quality issues.
Instructions
- Analyze the provided data sources to understand their structure and content.
- Identify relevant data fields and map them to a standardized format.
- Design a unified data structure that meets the requirements of the target application.
- Develop an integration plan that includes data transformation steps and error handling.
- Recommend strategies to resolve data discrepancies and ensure data accuracy.
Output format A data integration plan with sections: Source Analysis, Field Mapping, Unified Structure, Integration Steps, and Quality Assurance. Use diagrams or tables to illustrate mappings.
Guardrails
- Do not assume data schemas; ask for details if not provided.
- Flag any potential integration challenges or dependencies.
- Stay within the scope of integration planning; do not implement the solution.
Example Sources: Salesforce, MySQL, CSV exports; Purpose: Customer 360 view; Systems: CRM, Data Warehouse.
Follow-up prompts
- What are the best practices for handling real-time data integration?
- Can you suggest tools for automating the integration process?
- How can we ensure data security during integration?