Connecting to a DataSelf SQL Cloud Data Warehouse
DataSelf Cloud Data Warehouses are MS SQL Server databases hosted in AWS or Azure. DataSelf clients can connect to these databases via SSMS (SQL Server Management Studio), Excel, Tableau, PowerBI and DataSelf ETL+.
Requirements
A cloud MS SQL user license (username and password)
A URL to your MS SQL data warehouse (example:
dwX.dataself.com,1433
)The MS SQL database name(s) of your data warehouse (example:
DwXyzcorp
)Your public IP address whitelisted in DataSelf cloud data warehouse server(s).
Usually already done when connecting to the data warehouse from a network where ETL+ is already working (computers connected to a local network are commonly associated to the network's fixed public IP address whitelisted by ETL+).
A tool to connect to the cloud MS SQL database such as DataSelf ETL+, MS Excel, Crystal Reports, Tableau, Power BI, Qlikview, SSMS (SQL Server Management Studio), SSRS (SQL Server Reporting Services), and SSAS. See below for further instructions.
DataSelf ETL+
Your ETL+ comes pre-connected to your DataSelf cloud data warehouse, and allows easy, fast, scheduled and powerful extraction, transform and load processing. Click here for ETL+ User Guide.
SSMS
In SQL Server Management Studio (SSMS), click Connect -> Database Engine.
Enter the URL to your MS SQL data warehouse (example:
dwX.dataself.com,1433
).Select SQL Server Authentication.
Enter Login and Password.
Click Options.
Enter MS SQL database name in Connect to database (example:
DwXyzcorp_Erp
).Click Connect.
MS Excel
In MS Excel, go to the Data ribbon -> Get Data -> From Database -> From SQL Server Database
Server box: Enter the URL to your MS SQL data warehouse (ex.:
dwX.dataself.com,1433
)Database box: Enter MS SQL database name (ex.:
DwXyzcorp_Erp
).Click Ok.
Select Database on the left pane.
Enter User name and Password.
Click Connect.
Tableau Desktop
In Tableau Desktop right panel, click Microsoft SQL Server.
Server box: Enter the URL to your MS SQL data warehouse (ex.:
dwX.dataself.com,1433
)Database box: Enter MS SQL database name (ex.:
DwXyzcorp_Erp
).Select Use a specific username and password.
Enter User name and Password.
Click Sign In.
Power BI Desktop
In Power BI Desktop, select
Get Data
from the top ribbon thenSQL Server.
Server
box: Enter the URL to your MQ SQL data warehouse (ex: dwX.dataself.com,1433).Database
box: Enter the MS SQL database name (ex: DwCyzcorp_Erp).Typically you will be using the
Import
data connectivity mode.Select
OK
to proceed.Select
Database
then inputUser name
andPassword
and select Connect.
IMPORTANT: Power BI Service scheduled dataset refreshes require your DataSelf SQL Cloud Data Warehouse to be an Azure SQL Database. All other on-premises or private cloud data sources (including a MS SQL Database on an Azure VM) require the use of a Power BI Gateway to connect and allow scheduled dataset refreshes. See https://dataself.atlassian.net/wiki/spaces/TeckKB/pages/1611071910 for more information.