Before attempting to upload your accounts using DataShare Connect, please ensure the following:

• You have read THIS article
• The DataShare Connect Pre-requisites for user permissions are in place on your machine
• You are online and connected to the internet.
• You have a working Accounting Package and you are able to access the data you wish to upload within the Accounting Package.
• You know which version of Microsoft Dynamics Navision you wish to upload data from.
• You know the SQL Server Instance Name.
• You know the Database name you wish to upload data from.
• You know the SQL Server User ID and Password that can access the Microsoft Dynamics data.
• You know which Company you want to upload data from.

DataShare Connect will attempt to discover your SQL Server instance and populate the instance name for you. If you only have one instance of Microsoft Dynamics Navision installed on your desktop and this installation has only one company loaded DataShare Connect will automatically upload this company.

You may need to ask your IT department for some of the above information. ODBC DSN names can be found in the ODBC Administrator tool under the "System DSN" tab.

Launching DataShare Connect

To begin the upload process using DataShare Connect you need to be logged in to the DataShare Portal.

From within the DataShare portal choose the Engagement for which you wish to upload data.

Choose the Accounting Package from the drop-down menu.

When the correct Accounting Package is selected click the Upload Data button. This will start a download of the DataShare Connect vclient.application file. Your browser will show the download progress, in the example below Chrome was used and the vclient.application file can be seen in the download bar.

When the DataShare Connect vclient.application file has finished downloading, click it to begin the installation. 

Click on Install

The DataShare Connect application will now download in full and install to your desktop to begin connecting to your Accounting Package. The DataShare Connect package is quite small and will be automatically removed from your desktop once the upload process has completed unless you choose a scheduled upload.

DataShare Connect for Microsoft Dynamics Navision

Single Company Configuration

Once installed the DataShare Connect application will automatically launch and attempt to discover and connect to the Microsoft Dynamics Accounting Package.

If you only have one instance of Microsoft Dynamics Navision installed with only one company within that configuration, DataShare Connect will automatically begin the upload of that company without any further prompts or requests for credentials.

Depending on the size of your database and the number of entries it contains this process may take a few minutes. Once all data has been extracted the data is compressed, encrypted and transmitted securely to the DataShare central server.

You can continue with other tasks whilst the extraction takes place. Do not close the DataShare Connect window or interrupt the extraction process.

When the upload completes the success message is presented.

Click Close to exit DataShare Connect. At this point there is nothing more to do. Your Engagement Manager or Client Manager will be notified by email that you have submitted a new upload.

Your uploaded data is now being queued for processing in the DataShare central system. You can switch off your desktop and disconnect from the network at this point if you wish.

You can view the progress of your upload in the DataShare Portal - You may need to refresh your browser. The status will change from processing to complete.

Multi Company Configuration

Once installed the DataShare Connect application will automatically launch and attempt to discover and populate the instance name of the Microsoft Dynamics Navision SQL Server. When more than one Microsoft Dynamics Navision compatible database is discovered you will be asked to specify which database you wish to use.

Enter the SQL Server Instance Name and the Database Name.

When the SQL Server Instance Name and Database Name have been completed the Next button will appear. Click Next to proceed.

Choose the Company that you want upload and click Next.

The DataShare Connect data extraction process will begin and progress will be displayed on screen.

Depending on the size of your database and the number of entries it contains this process may take a few minutes. Once all data has been extracted the data is compressed, encrypted and transmitted securely to the DataShare central server.

You can continue with other tasks whilst the extraction takes place. Do not close the DataShare Connect window or interrupt the extraction process.

When the upload completes the success message is presented.

Click Close to exit DataShare Connect. At this point there is nothing more to do. Your Engagement Manager or Client Manager will be notified by email that you have submitted a new upload.

Your uploaded data is now being queued for processing in the DataShare central system. You can switch off your desktop and disconnect from the network at this point if you wish.

You can view the progress of your upload in the DataShare Portal - You may need to refresh your browser. The status will change from processing to complete.