SQL Editor

Updated
  • Updated on Sep 15, 2025
  • Published on Jun 6, 2025
  • 3 minute(s) read
  • AF
 Prev Next

Overview

SQL Editor is a unified interface for creating, executing, and managing SQL commands directly in the Migrate module, eliminating the need for external SQL querying tools while maintaining security through controlled access and permissions on your Datasources. SQL Editor prevents unauthorized database access risks, provides audit trails for all database operations, and ensures compliance with security policies.

The integrated AI-powered SQL Assist service enhances productivity by helping users write, debug, explain, and optimize SQL statements through conversational interaction. Refer to SQL Assist for more information.

Refer to Working with SQL Editor for more information on the functionalities and features available in SQL Editor.

Supported Database Systems

Currently, the following database systems are supported for SQL scripting in SQL Editor:

  • Microsoft SQL Server

  • PostgreSQL

  • SAP HANA

Note

To see Datastores in the Object Explorer panel, they must be registered as Datasources in Migrate.

Key Features

  • Datastore Object Explorer: SQL Editor displays a hierarchical tree structure of the database schemas and objects present in your selected datastore, showing available schemas and its objects. The tree structure representation helps you navigate complex datastore structures and reference objects.

  • Query Execution with Controlled Permissions: You can only perform the operations granted to your role in SQL Editor. This security measure prevents unauthorized access risks while providing audit trails and ensuring policy compliance. Refer to the Roles and Permissions section below for more information.

  • User-Friendly Querying Panel: A comprehensive SQL development environment that combines traditional code editing capabilities with modern AI assistance and integrated database management features.

  • History and Script Change Tracking: Monitor all query modifications and execution history. Copy previous queries directly from the History panel to reuse or modify existing SQL statements.

  • AI-Powered SQL Assistant: SQL Assist revolutionizes SQL development through conversational AI interaction, intelligently understanding your datastore structure to provide contextual assistance for database operations.

Roles and Permissions

The following table outlines user roles and their associated permissions, which can be used to assign appropriate access levels and prevent unauthorized access:

Note

You'll receive an error message if you don't have the privilege to run a particular statement.

Role

Permissions

Migrate Read-Only Analyst

Can execute DQL statements (SELECT) to view or retrieve data from authorized data objects.

Migrate Contributor

Has access to DQL and DML statements (for example, INSERT, UPDATE, and DELETE) on authorized data objects.

Migrate Developer

Includes all Contributor permissions, plus the ability to execute DDL statements (for example, CREATE, ALTER, DROP, and TRUNCATE) on data objects within authorized datastores and schemas.

Migrate Administrator

Includes all Developer privileges, with additional access to execute queries on all data objects across the entire database system in the SKP tenant.

Accessing SQL Editor

You can access SQL Editor in the following methods:

  1. Using the SQL Editor link in the Migrate card on the Syniti Knowledge Platform home page.

  2. From the Migrate menu using the following path: Administer > Advanced > SQL Editor.

  3. From the Target Reports page (accessed via Migrate > Mappings > Targets panel > Reports column):

    1. In the Actions column, using the Open in SQL Editor icon for the associated target report.

    2. In the Report DDL dialog box, using the Open in SQL Editor button when viewing/editing a specific Target Report details.

  4. From the ETL Tasks page (accessed via Migrate > ETL Jobs > Edit an ETL Job or Migrate > Mappings > ETL column):

    1. Using the Open in SQL Editor icon when viewing ETL Task list in an ETL Job.

    2. Using the Open in SQL Editor button in the Rule DDL tab of the Edit ETL Task dialog box when editing a specific ETL Task’s details.

Methods 3 and 4 opens the SQL Editor page in a new tab with the associated DDL script of the respective report view or ETL rule.

Refer to Working with SQL Editor to read more about functionalities and features available in SQL Editor.

Related Articles