Talk to sales
Integration details

Microsoft SQL Server

Discover database metadata and extract rows with explicit incremental settings.

Plan your pilotExplore walkthroughs
All integrations
Implemented connector

Ad-hoc SQL uses the governed Query IDE path. The legacy connector shim does not execute arbitrary queries.

Supported operations

  • Test connectivity and discover table metadata.
  • Preview source rows and read full datasets.
  • Read incrementally with an explicit cursor column.

Authentication and access

SQL Server credentials with encrypted transport settings.

Keep credentials in your approved secret-management workflow. Confirm network access and least-privilege permissions with the source owner.

Connection walkthrough

1

Grant the source account access to the required tables and metadata.

2

Configure the server, database, credentials, and transport settings.

3

Test schema discovery and validate a sample extraction.

Put the connection to work

Connect existing finance and operations databases to a reconciliation workflow.

Land an approved sample, validate its schema and record counts, then publish it with ownership and a refresh expectation. Review the output with its intended consumer before expanding access.

Explore GeneFlow EngineeringChoose an implementation kit