Testing Connections to DS Cloud Server with Excel

Owned by Cortlandt _
Oct 06, 2023
2 min read

Using Excel to test connections to client computers outside of ETL+.

This test can be run either with Excel or with Microsoft SSMS. See https://dataself.atlassian.net/wiki/spaces/ETL202208/pages/2032245788 for testing with SSMS.

How to Run a Connection Test with Excel

  1. Open Microsoft Excel On your computer.

  2. Data tab > Get Data > From Database > From SQL Server.

  3. On SQL Server database window enter dw3.dataself.com,1433 in Server.

    1. SQL Server database window.

  4. Enter connectiontest in Database.
    For more about the connectiontest database see .

  5. Click OK.