Microsoft SQL Server / MS SQL (beta)
Follow these steps to connect your Microsoft SQL server instance to Select Star.
Last updated
Was this helpful?
Follow these steps to connect your Microsoft SQL server instance to Select Star.
Last updated
Was this helpful?
For instances operating within a non-publicly accessible environment, such as a private network, please refer to our guide on for detailed instructions and best practices.
We recommend creating a dedicated service account for Select Star with metadata-only roles and permissions.
Execute the following command:
Execute the following command:
Display Name - The Name you want to give to your new datasource.
Hostname - Your hostname defines the location where your database is hosted.
Port - The communication endpoint used to connect clients to the SQL Server instance.
Username - Specify the User to connect to the SQL Server instance. It should have enough privileges to read all the metadata.
Password - Password.
Database - The database name.
After you fill in the information, you'll be asked to select the databases you'd like to load into Select Star.
Your metadata should start loading automatically, once the sync is complete, you'll be able to see it in Select Star.
See the link below for more information on how to navigate through data warehouses.
Select Star platform supports various query log sources, for optimal selection, please refer to .
You can you have loaded if needed.