Advanced Data Access

Modified on Wed, 29 Nov 2023 at 02:33 PM

Some companies using Evolution have a need to access more data than is offered in our standard data access. Please contact Sales for pricing and availability. If your company has access to Advanced Data Access this is how you connect to it. 


Security:


A secure connection will need to be established. This was reviewed with your IT team when you purchased Advanced Data Access.  


Connection String:


This will be provided by our support team. If you do not have this or would like it changed please contact support. 



ODBC:


Prerequisites: 


Microsoft ODBC Driver for SQL Server version 17.2.0.1 or later for your operating system.

  1. In Windows, search for ODBC Data Sources, and open the ODBC Data Sources desktop app.

  2. Select Add.

    Add data source.

  3. Select ODBC Driver 17 for SQL Server then Finish.

    Select driver.

  4. Enter a name and description for the connection you were provided.

  5. Enter the database provided and click Next.

    Change default database.

  6. On the next screen, leave all options as defaults then select Finish.

  7. Select Test Data Source.

  8. Verify that the test succeeded then select OK. If the test didn't succeed, check the values that you specified in previous steps.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article