Skip to content
RebelCore Docs

Microsoft SQL connector

The Microsoft SQL connector exposes approved SQL Server views to the dataset import blade.

Configuration

In Customer Settings -> Connectivity, configure Microsoft SQL with:

  • Hostname or server name
  • Port, normally 1433
  • Database name
  • Authentication method
  • Network mode
  • Connection secret

The connection must be enabled, have a stored secret, and have an Active status before it appears in the import blade.

Authentication

Use a least-privilege account for RebelCore. The account needs read access to the approved v_rc_ views and to the metadata required to list view columns.

For SQL login authentication, store the connection secret as either a SQLAlchemy-compatible URL or a SQL Server ODBC connection string.

Connectivity

The database must be reachable from the RebelCore worker environment by the configured network route. If your organisation requires private connectivity, complete the private endpoint approval and DNS setup before marking the connector active.

Supported objects

Only views are supported. The import blade lists views whose names start with v_rc_.

Tables, stored procedures, functions, synonyms, and arbitrary SQL queries are not imported.

View requirement

Create client-facing views with names like:

CREATE VIEW dbo.v_rc_customer_orders AS
SELECT ...

Only the selected view is read, and rows are read when RebelCore builds and vectorizes the gold semantic dataset.