Testing Connections to DS Cloud Server with Excel

Owned by Cortlandt _
Jun 24, 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 Testing Connections to DS Cloud Server 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.

 

Related Pages

Â