SQL Server

Overview

The SQL Server connector can be used to load rows from SQL Server tables or views into xpna.

This connector is commonly used for operational datasets, warehouse views, or prepared reporting tables.

The following details are required:

Note:

Credentials are stored encrypted in xpna.
A read-only database user should be used where possible.

Tables or views are selected as source items in the configuration.

Sample data can be requested so that columns can be reviewed, typed, and mapped before the configuration is saved.

Data can be refreshed manually from the Connections page or by using the configured schedule.

If the selected table or view schema changes, sample data should be refreshed and the column configuration should be reviewed.