Note: Metaplane supports SQL Server hosted on-premise and/or in your cloud network.
As a super user, execute the following SQL commands to create a login, a user assigned to that login, and permissions to access a schema.
Make sure to generate a secure password and store it securely — you'll save it into Metaplane later.
CREATE LOGIN MetaplaneLogin WITH PASSWORD = 'changeme'; CREATE USER MetaplaneUser FOR LOGIN MetaplaneLogin WITH DEFAULT_SCHEMA = [DBO];
Then for each schema you would like to monitor, execute the following command to grant read-only access:
GRANT SELECT ON SCHEMA :: dbo TO MetaplaneUser;
If you are not using
dbo as the default schema, be sure to change the commands to use the schema name that contains tables you would like Metaplane to monitor.
To add a Microsoft SQL Server source, navigate to the Connections page and click the SQL Server button. A modal will prompt you for the credentials you just created, then allow you to save the connection for testing.
Metaplane supports both SSH and Reverse SSH tunnel setups. Use the checkbox in the modal shown below to use either option.
Metaplane will always connect to your data warehouse from these static IP addresses:
Updated 3 months ago