Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerpt

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 PowerBIDataSelf 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.

...