Overview
The Data Exchange provides direct access to your high-value Evolve ATS data. Data Exchange allows you to drill directly into your data with any BI tool you choose and create your own queries and visualizations.
Audience
All users
Connection Set-Up
Connections to Data Exchange can be made via JDBC or ODBC to any database management or BI tool. For either connection type, the appropriate driver below must be downloaded.
Driver Type | Operating System | Link to Driver |
JDBC | Any | https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc/3.11.1/snowflake-jdbc-3.11.1.jar |
ODBC | Windows, Mac, Linux | https://sfc-repo.snowflakecomputing.com/odbc/index.html |
Database Management Tool Connections
Instructions for configuring the driver and setting up ODBC and JDBC connections can be found at the links below.
Driver Type | Operating System | Link to Driver |
JDBC | Any | https://docs.snowflake.net/manuals/user-guide/jdbc.html# |
ODBC | Windows | https://docs.snowflake.net/manuals/user-guide/odbc-windows.html |
Mac | https://docs.snowflake.net/manuals/user-guide/odbc-mac.html | |
Linux | https://docs.snowflake.net/manuals/user-guide/odbc-linux.html |
BI Tool Connections
If your BI tool doesn’t have a native Snowflake connector, you can follow the instructions above to set up an ODBC or JDBC connection. Instructions for several popular BI tools are below. A full list of BI tools with available Snowflake connectors and instructions can be found at: https://docs.snowflake.net/manuals/user-guide/ecosystem-bi.html
Support
Please submit a Help Center Ticket for assistance with service requests or adding additional users.
For connectivity issues or other compatibility questions, navigate to this link:
https://docs.snowflake.net/manuals/user-guide-connecting.html
FAQ
Q. Will I have all my data?
A. No. Currently, a standard set of tables and fields is available that all customers use. Please review the data dictionary and ERD diagrams for current data capabilities.
Q. How do I get access to data I don’t have?
A. We will build more data into the Warehouse as the platform updates and expands. If items are not present, please follow the current enhancement request process.
Q. Will I have access to my ATS custom fields?
A. Custom fields have been added for the following entities. These fields are surface in a View per entity. Each View has a row per custom field and custom field value combination.
- Application – application_custom_fields
- Job – job_custom_fields
- Company User – company_user_custom_fields
- Contact – contact_custom_fields
Q. Can I change the data structure?
A. No – All customers will use a standard data model. Additional tables may be added over time to account for custom fields, but all customers will use the same base data model.
Q. Can we increase the frequency of the refresh time?
A. The refresh time is currently set to every 4 hours. We are not planning to increase the refresh cadence at this time.
Q. Can we set up additional users?
A. Yes – additional Data Exchange users can be set up. Please submit a support request with the Name, Email, and access they should have.
NOTE: Password changes must currently be requested via a Help Desk ticket.