---
title: "dsCONNECT User Guide v2.0.0"
canonical: "https://servicedesk.maxgeo.com/space/mxAPI/2342223873/dsCONNECT%20User%20Guide%20v2.0.0"
format: markdown
---
> Macro (toc)

*This guide shows how dsConnect lets licensed users pull MDS data into a local SQL Express database, customize and group data layouts/tables, and automate regular refreshes. It explains creating/editing layouts and tables (including handling geometry fields), testing connections, exporting/importing configurations, and exporting data to Excel/CSV/Access. Follow it to set up reliable, repeatable local copies of MDS data and streamline team configurations.*



The **dsConnect** application allows licensed users to download data directly from the datashed **MDS** and save it locally in a **SQL Express** database on their own workstation.

![dsCONNECT User Guide - Step 0.jpeg](media://445e68f7-1fa5-4f42-ab6c-5e691b1bf146)



# System Requirements

> ⚠️ - [mxAPI Licensing and User Requirements](https://servicedesk.maxgeo.com/space/mxAPI/1797455873/mxAPI+Licensing+and+User+Requirements)
> ⚠️ - DataShed5 version 3.2 or newer
> ⚠️ - mxAPI v1.5.3.0 or later
> ⚠️ - Application installed as per [installation guide](https://servicedesk.maxgeo.com/space/mxAPI/1784348754/dsCONNECT+Installation+Guide+v1.0)

> ⚠️ Each client has a **unique API URL**. To use dsCONNECT, users must enter their organisation’s specific API endpoint.
> ⚠️ 
> ⚠️ For maxgeo Cloud clients, the API URL format is:
> ⚠️ 
> ⚠️ ```
> ⚠️ https://companynamemxapi.maxgeo.com/api/v2/
> ⚠️ ```
> ⚠️ 
> ⚠️ If you are unsure of your correct API URL, please contact the [maxgeo Service Desk](https://maxgeo.atlassian.net/servicedesk/customer/topic/2514cec8-77bc-4396-822b-b8461006535b) for assistance.

> ℹ️ [Download the dsConnect installer here.](https://s3.ap-southeast-2.amazonaws.com/updates.maxgeo.com/software/dsCONNECT/v1.0.2.0/dsCONNECTInstaller_v_1.0.2.exe)

# Application Information

Click the **?** button to open the MDS Version Information dialogue

![dsCONNECT User Guide - Step 2.jpeg](media://304efe99-cfa4-4d22-80a6-7566df9b13df)





# The dialogue displays:

1. MDS Version
2. Available Layouts
3. Total Destination Tables
4. Application Version
5. API Version

![dsCONNECT User Guide - Step 3.jpeg](media://2bb0f070-a639-43d9-8ded-e529bc8b5a53)



Click **OK** to close the dialogue.

![dsCONNECT User Guide - Step 4.jpeg](media://d52e47f5-48e6-47b1-bb28-04a6b6227f7b)





# Layouts

The default installation comes with three Layouts

1. **ArcGIS** - 5 tables
2. **IOGAS** - 5 tables
3. **LeapFrog** - 14 tables

Switching between Layouts is done by clicking the Layout dropdown list and selecting the desired Layout.

![dsCONNECT User Guide - Step 6.jpeg](media://077b2161-ec53-4dd7-8ced-960a8eb474cb)



## Edit an Existing Layout

Select the Layout to work with, then click the **Edit** button.

![dsCONNECT User Guide - Step 8.jpeg](media://60243823-cf2e-458b-8866-f57b42711491)






In the Edit Layout dialogue, the following items can be edited:

1. Layout Name
2. Description
3. MDS Version (This can be maintained by the Test Connection feature)

![dsCONNECT User Guide - Step 9.jpeg](media://35668d01-8e55-4fb3-8187-5028c12ebdf6)




## Creating a New Layout and Adding a Custom Table

Click the **+** button

![dsCONNECT User Guide - Step 11.jpeg](media://af789c8d-60c6-454e-a2a8-008311d73ee7)





The **Create New Layout** dialogue opens

![dsCONNECT User Guide - Step 12.jpeg](media://13c6b57c-d7dc-447c-a22b-94e94e1725be)




Enter a **Layout Name** and **Description**, then click **OK** to create the Layout

![dsCONNECT User Guide - Step 13.jpeg](media://311f595b-b4ef-4ed1-b8d5-5764f84e7b0b)




A success message is displayed, click **OK** to close this message box.

![dsCONNECT User Guide - Step 14.jpeg](media://d4e21159-90cf-417c-bb34-dd3d0e5bdce6)




Click the **Add Table** button

![dsCONNECT User Guide - Step 15.jpeg](media://2ef5afa2-e237-43bd-a3ed-837ad1389113)





The **Create New Destination** **Table** dialogue will open.

![dsCONNECT User Guide - Step 16 (1).jpeg](media://5526067f-4e6e-4894-95bf-327654bd471d)


This window can be resized.

Enter the following fields:

1. Display Name - The name displayed in dsConnect
2. Table Name - The name used in the table in SQL Express (see Tip below)
3. Description - A meaningful description of the table
4. SQL Query - The SQL statement that will select the required data.

> ✅ **Tip!** It is recommended to name the table with the Layout name and "_" then a table name. This will keep all Layout tables grouped together in SQL Express.

> ✅ **Tip!** To limit data to a specific **DataSet**, include a **where DataSet='xxx'** in the SQL query.

> ⚠️ SQL statements in dsConnect are **case sensitive**. Please ensure to use the same case for **table and** **field names** as they appear in the MDS.

> 📝 **Note:** All SQL Select statements must contain the fields **DataSet **and** Load_Date**. dsConnect will only download SQL statements that contain the **DataSet **and** Load_Date** fields. This is how dsConnect limits your data download to data belonging to the **DataSets** you have been granted access to, and can refresh tables in paginated chunks.
> 📝 
> 📝 If the **DataSet **and** Load_Date** fields are not included in the SQL query, the below (or similar) warning will be displayed.

![DataSet error.jpg](media://54a0fea3-3369-4897-9696-a706495b9e4d)



![dsCONNECT User Guide - Step 17.jpeg](media://267c18d9-4ed0-4744-96ae-e7b2b1f71dd7)



> 📝 **Note:** If your SQL Select contains a field of type “geometry”, you will need to cast the field to a different data type. This may be common when using a **MDS v5.0.0** database or above.
> 📝 
> 📝 ie. CAST([Preferred_Geometry] AS NVARCHAR(MAX)) as Preferred_Geometry
> 📝 
> 📝 **Example:** SELECT [Lease_ID]
> 📝 
> 📝                       ,[AuthorityCode]
> 📝 
> 📝                       ,**CAST([Preferred_Geometry] AS NVARCHAR(MAX)) as Preferred_Geometry**
> 📝 
> 📝                       ,[ObjectID]
> 📝 
> 📝                  FROM [tblVWDHCoordinates]

> 📝 **Note:** If your query contains a field type unrecognised by dsConnect, and the table name is the same as the Query table name, you will be prompted to Cast the field to Text. Click "Yes" to proceed with this, or "No" to manually enter a Cast statement.

![DSCONNECT User Guide - Step 21 (1).png](media://10125a75-64b8-4d90-8591-803fa069ca34)


The changes will be displayed in a popup. Click **OK** to proceed.

![dsCONNECT User Guide - Step 22.jpeg](media://b18865af-1623-4713-bf39-3c5d62d00724)



Click **OK** at the popup indicating the fields that were Cast to Text.

![DSConnect User Guide - Step 22.png](media://07f0a50f-5eb0-40b0-8735-96bad2be85d6)

Here is the automatically Cast Field.

![dsCONNECT User Guide - Step 23.jpeg](media://5a6e3241-d0bd-4b3e-8921-d5523c4006e5)





After completing the above details, click **OK** to save the table definition.

![mxConnect User Guide - Step 19 (1).png](media://a5330002-f8b6-4d86-be92-4f2f393b56d9)



A success message will be displayed. Click **OK** to close this message.

![mxConnect User Guide - Step 20 (1).png](media://35b72a39-9104-462a-9455-968251e50c9f)



The new table will be displayed in the Destination Tables for the new Layout.

![dsCONNECT User Guide - Step 24.jpeg](media://d35ef229-db94-41b7-8dde-c5fadc6f3fea)





# Loading Data to Tables

To load data or refresh data in a Table, select the table then click the **Update Selected Table** button.

![dsCONNECT User Guide - Step 26.jpeg](media://9d3cdb0e-518f-445f-9586-56c97abf1251)





The **Status** panel at the screen bottom will display the progress. When the Table data has been updated, a success message will display.

![dsCONNECT User Guide - Step 27.jpeg](media://8b02d26d-3fef-436b-ba1e-9c522074fa19)





Click **OK** to close the message box.

![dsCONNECT User Guide - Step 28.jpeg](media://6cb0e979-d8a1-4ed9-9951-4c370971430c)




## Update All Tables in a Layout

Click the **Update Selected Layout** button. This will refresh data in all the tables in the selected Layout.

![dsCONNECT User Guide - Step 30.jpeg](media://a2a3e674-bcd3-470e-bcf2-8eabd3dbaa20)





Click **Yes** on the **Refresh Layout Table** dialogue

![dsCONNECT User Guide - Step 31.jpeg](media://98b45d90-14b9-4c5b-b5e9-5401814bc0cd)



The Status panel will show the update progress.

![dsCONNECT User Guide - Step 32.jpeg](media://6c689646-2d7b-4f90-95b0-d319ece304ab)




Click **OK** on the success message box

![dsCONNECT User Guide - Step 33.jpeg](media://06e5fe10-3574-4a19-9ed3-192a083fe98d)



Then the below will show any tables that failed to update.

![dsCONNECT User Guide - Step 34.jpeg](media://af658067-9e15-4fc4-a9e0-e00c25a892e5)



## Update Data in All Tables in All Layouts

Click the **Update all Tables** button and follow the message boxes as above. This will refresh data in all tables in all Layouts.

![dsCONNECT User Guide - Step 36.jpeg](media://103457bd-a9b7-48fb-bb84-f1024558435d)




# Delete a Layout

Click the **Delete** button

![dsCONNECT User Guide - Step 38.jpeg](media://7de0fd21-2f5a-458c-9ac5-70888b118cda)




A warning message box will display "**Are you sure you want to delete the layout 'Test'?**

This will also delete 1 associated destination table(s) and their configurations."

![dsCONNECT User Guide - Step 39.jpeg](media://3320e96d-ab81-40ae-bec9-dc9816a69068)




Click **Delete Layout** to delete the Layout

![dsCONNECT User Guide - Step 40.jpeg](media://58813447-84bc-4322-ad2c-742906c909ed)




A success message box will be displayed. Click **OK** to close this message box.

![dsCONNECT User Guide - Step 41.jpeg](media://5e11a60b-73eb-4bd4-9442-72184f9f385c)




# Schedule Automatic Data Table Refresh

Select the **Frequency Type** for the Refresh

![dsCONNECT User Guide - Step 43.jpeg](media://0a580b62-0832-487a-b1ab-8ddec776e443)


Click the **Clock** icon to open the **Time Chooser**.

![dsCONNECT User Guide - Step 44.jpeg](media://bf1d6bc7-a0f2-4d49-858b-2eafbe847fed)


Select the desired **Hour**.

![dsCONNECT User Guide - Step 45.jpeg](media://67c1b1a0-37ee-4c1e-841b-ae5d9ea69a36)


Click "**Minute**" to choose the desired Minute.

![dsCONNECT User Guide - Step 46.jpeg](media://d285e272-6b92-4f50-8bdf-2abfe914f2f5)


And select the minute setting.

![dsCONNECT User Guide - Step 47.jpeg](media://08261f8c-d86e-4661-82de-1ab2cf3c502b)


Choose **AM** or **PM.**

![dsCONNECT User Guide - Step 48.jpeg](media://91e70830-7496-4380-aa45-cbdc1d29d6d9)


Click "**OK**" to set the Schedule.

![dsCONNECT User Guide - Step 49.jpeg](media://8e8456c2-09a7-4dbb-9b59-29d749143faf)


Click "**Yes**" to confirm the Schedule.

![dsCONNECT User Guide - Step 51.jpeg](media://20366902-d11a-47c1-9a16-2641a9f111ab)


The Status panel will show the Schedule activation progress.

![dsCONNECT User Guide - Step 52.jpeg](media://d6aae829-7c61-4e0d-8c34-7da798a2a776)



## Disable a Scheduled Refresh

Untick the "**Enable Schedule**" check box.

![dsCONNECT User Guide - Step 54.jpeg](media://7c38cd39-0d6c-40da-b0db-437b7b184f59)



# Exporting Data

Data can be exported from the **SQL Express** tables in three formats:

1. **Excel** - Creates an Excel workbook with a tab for each table
2. **CSV** - Creates a CSV file for each table, named after the table name.
3. **Access DB** - Creates an Access database with an Access table for each Layout table.

When exporting data, all data from all tables will be exported.

![dsCONNECT User Guide - Step 57.jpeg](media://42bdd033-b8c9-4109-8792-d32a05cf1a14)


Select the Export format and the Export file location and name, then click **Export Data Now**

![dsCONNECT User Guide - Step 67.jpeg](media://7c7fac91-b055-44c6-8bda-ce4894f70995)


Click **Yes** to confirm to continue with the Export

![dsCONNECT User Guide - Step 68.jpeg](media://3db7731b-764f-46db-8342-ebe0f79ddfa4)


A progress bar will indicate the export status.

![dsCONNECT User Guide - Step 69.jpeg](media://427b8e93-b52f-4b7f-b1c3-07e018d072ef)


After the Export has completed, a message box displays with the results, click **OK** to close

![dsCONNECT User Guide - Step 70.jpeg](media://41a713b1-544f-4457-996d-ba3be97fd964)



# Settings

The Setting tab allows a user to check and edit the configuration parameters for the SQL Express database and the API connection to the DataShed MDS.

Data Export can also be run. Configuration settings can be Exported or Imported.

To access Settings, click the **Settings** tab

![DSCONNECT User Guide - Step 69.png](media://26981d47-65a3-4e88-993f-610604f76373)



## **Database Settings**

Click **Test Database Connection** to test the connection to your SQL Express.

![DSCONNECT User Guide - Step 70.png](media://1789f0b7-8dd2-4de7-b8c3-5a7a70b43ae4)




A message box will display the Test results. Click **OK** to close.

![DSCONNECT User Guide - Step 71.png](media://4ccd32bc-a0d8-4a20-9a7f-ec59c076eeef)




## **Check the MDS Verision**

Click the **Re-check MDS Version** button

![DSCONNECT User Guide - Step 75.png](media://d2f8b967-650f-4c93-9bd5-1d32a1a462e5)




A message box will display the details. Click **OK** to close the message box.

![DSCONNECT User Guide - Step 76.png](media://9963717b-7b26-4f4c-a9fd-be19690697e8)




## **Check the Environment Connections**

Click the **View/Edit Environment Configuration** button to

![DSCONNECT User Guide - Step 79.png](media://820e90b1-b670-4dca-a91d-a35da73e11d9)




A dialogue display showing two tabs and some action buttons at the lower left.

The **API** tab allows the API URL and the API Key to be updated.

![DSCONNECT User Guide - Step 80.png](media://1f443680-7197-423f-ba09-f90ce884924d)




The **Database Settings** tab allows the SQL Express settings to be modified.

![DSCONNECT User Guide - Step 82.png](media://ded80b8a-41ef-4e0a-84f4-bc207ffbb0d4)




## **Test API Connection**

The **Test API Connection** button will test if the API is configured correctly

![DSCONNECT User Guide - Step 86.png](media://5847c683-6cf4-4e70-b58e-352aa651efe9)




A message box will display the results. Click **OK** to close.

![DSCONNECT User Guide - Step 87.png](media://70ff01bb-9fb1-4cf1-b943-37d9e86e3f5b)




## **Test the SQL Express Database Connection**

To test the SQL Express Database Connection, click the **Test Database Connection** button

![DSCONNECT User Guide - Step 90.png](media://a50fa34b-20c5-4e09-b6c4-13f35b96bf9c)




A message box will display the results, click **OK** to close

![DSCONNECT User Guide - Step 91.png](media://92049b11-ad6e-4a1e-bdc6-5e1e6cd56081)


## Export Configuration

The Export Configuration option will export the configuration to a JSON file. This file can be shared with team members and imported to make configurations quickly and consistently for multiple users.

To export the configuration, click **Export Configuration**

![DSCONNECT User Guide - Step 98.png](media://c61aa07d-e5d9-42df-86dd-40251faac83a)




Enter a filename and select an export location, then click **Save**

![DSCONNECT User Guide - Step 99.png](media://712d8a0b-8007-4362-b5e0-d770822f1f2a)




A success message box will be displayed, click **OK** to close

![DSCONNECT User Guide - Step 100.png](media://11fc2a00-8830-4493-9477-50779619d4ef)



## Import Configuration

Configurations that have been exported from a users DSConnect can be imported to help speed up installation and keep all Users configurations the same.

Click **Import Configuration**.

![DSCONNECT User Guide - Step 105.png](media://ff1fc006-869e-4eb5-ad2a-7fa0140fd2ea)




Navigate to the file location annd select the JSON file, then click **Open**.

![DSCONNECT User Guide - Step 107.png](media://01a7c419-a86e-4086-96ee-05b48db55b01)



The **Import Configuration** message box will display asking if you want to merge with existing configuration. **Yes** will merge with existing, meaning the configuration file settings will be added to the existing settings. **No** means the existing settings will be replaced with the settings in the JSON file.

![DSCONNECT User Guide - Step 108.png](media://4483dbf1-ea9e-4a1d-955d-888b3c8f8eae)



After the import has been done, a success message box will display. Click **OK** to close.


![DSCONNECT User Guide - Step 109.png](media://124f6292-acce-42dc-95f0-fba1c1431dcb)