Automated replication pipeline designer - Precisely Data Integrity Suite

Key benefits

• Step-by-step guidance for mapping configuration: The Gio™ AI Assistant walks you through each stage of the setup, so you never have to figure out the sequence on your own.

• Automated suggestions for field mapping and transformations: The system identifies and pre-fills relevant tables and schemas based on your intent, saving you from manual lookup.

• Real-time validation and feedback: Errors and missing information are caught immediately, so you can correct them before saving.

• Consistent, repeatable mapping processes: Every pipeline follows the same structured workflow, making it easier to maintain and audit.

• Significantly reduced manual setup and configuration effort: What might take hours of manual configuration can be done in minutes through guided conversation.

How the automated replication pipeline designer works

The Automated Replication Pipeline Designer uses the Gio™ AI Assistant to understand what you want to replicate and create the pipeline for you. You can describe your replication goal in one message or build it up gradually. Gio™ AI Assistant will guide you through each step, ask for anything that is missing, and validate your setup before moving forward. Every pipeline is created through three phases that always run in order:

Phase 1: Project and Pipeline Setup

Gio™ AI Assistant creates a new project (or lets you select an existing one) and initializes a pipeline inside it. A project is simply a container that holds one or more pipelines. A pipeline cannot exist without a parent project.

Phase 2: Connection Validation and Linking

Gio™ AI Assistant checks that your source and target database connections are compatible with each other based upon your request, then links them to the pipeline. If the requested connection is not compatible, Gio™ AI Assistant will notify you that the connection request is invalid.

Phase 3: Table and Schema Mapping

Gio™ AI Assistant discovers available tables from your source connection based on the names or patterns you provide and configures the replication mappings. You review the matched tables before the pipeline is finalized and executed. Gio™ AI Assistant handles the sequence automatically and will only ask you for input when it needs to.

What you can do with Gio™ AI Assistant

• Create a new replication pipeline from scratch: Provide your source, target, and table details all at once or step by step, and Gio™ AI Assistant builds the full pipeline for you.

• Create a pipeline with just source or target details: You don't need to specify both sides upfront. If you provide only the source, Gio™ AI Assistant fetches available target connections for you to choose from, and vice versa.

• Create a pipeline with only connection types: If you say something like "Postgres to Snowflake", Gio™ AI Assistant will find all matching connections in your workspace and let you pick.

• Create a pipeline with no connection details at all: If you just say "Create a replication pipeline", Gio™ AI Assistant will list all available connections in your workspace for you to select from.

• Browse and select from existing projects: You can ask Gio™ AI Assistant to list all your existing projects and choose one to use for your new pipeline.

• Create a pipeline under a named new project: You can specify a new project name and Gio™ AI Assistant will fetch the list of existing projects for you to review. To create the new project, select the Create New Project button and Gio™ AI Assistant will create the project with the name you provided and initialize the pipeline inside it. If a project with that name already exists in your workspace, Gio™ AI Assistant handles the conflict automatically by appending a unique identifier to the name, you will not be asked about it.

• Select tables and schemas using names or patterns: You can specify exact table names, schema names, prefix patterns, suffix patterns, or keyword-based selections in plain language.

• Add more tables to an existing selection: After reviewing the matched tables, you can ask Gio to include additional tables and it will merge them with the existing selection.

• Replicate all tables in a schema: You can ask Gio™ AI Assistant to replicate all tables within a specific named schema or select all tables and all schemas at once using clear all-grant phrases.

What you cannot do with Gio™ AI Assistant

• Modify or edit a pipeline: Once a pipeline has been fully configured and saved, Gio™ AI Assistant cannot reopen or edit it. For changes to a completed pipeline, use the manual configuration options in the Data Integrity Suite.

• Filter or search projects by name pattern: You can only list all projects. Gio™ AI Assistant does not support filtering projects by name patterns or wildcards such as "Show projects starting with PRODUCTS".

• List connections without a pipeline context: Gio™ AI Assistant cannot browse or list connections independently without first initializing a project and pipeline. Asking to list connections on their own is outside the scope of this agent.

• Use vague or placeholder table inputs: Inputs like "all data", "replicate everything", "sync all datasets", or placeholder text like [Tables] or [Schemas] are not accepted. You must provide specific table names, schema names, or patterns.

• Create custom table mappings: Mapping a source table to a differently named target table by natural language is not supported. Target tables are always created automatically by the system with the same name as the source.

• Use unsupported connection type combinations: Not all source and target combinations are supported. If you specify an incompatible pair, Gio™ AI Assistant will stop and show you the valid combinations for your source type.

• Create pipelines for general data tasks: Gio™ AI Assistant is a specialized replication pipeline agent. Requests unrelated to creating or configuring a replication pipeline are outside its scope.

Common use cases

Typical Workflow

1. Start the Automated Replication Pipeline Designer in the Data Integrity Suite.

2. Provide your replication intent.

3. Respond to AI prompts for any missing or ambiguous information.

4. Review the automatically generated or updated pipeline, including object selections and mappings.

5. Confirm and save the pipeline for execution or further customization.

Sample Queries

Below are example queries you can use to interact with Gio™ AI Assistant. You do not need to follow a strict format, plain natural language also works. The more specific you are, the faster Gio™ AI Assistant can build your pipeline.

Best Practices

• Clearly specify your replication goals and preferences for optimal AI guidance.

• Review AI-generated mappings and configurations before saving the pipeline.

• Use incremental intent refinement for complex or evolving requirements.

• Leverage AI-driven modification to update existing pipelines efficiently.

Results

The Automated Replication Pipeline Designer accelerates pipeline creation, reduces manual configuration, and ensures accurate, consistent replication processes. By leveraging AI guidance, you minimize errors and gain confidence in your data integration workflows.