Establish a Connection

Version 24.2.9039


Establish a Connection


Before creating your first API, you need to connect to your data source. Arc supports connecting to the following data sources:

  • SQLite
  • MySQL
  • SQL Server
  • PostgreSQL
  • Oracle
  • DB2
  • Excel
  • Azure Data Lake Storage

Note: Data sources referenced in the API connector that require licensing should be licensed on the machine outside of Arc.

Once you select the Data Source Type on the Connection tab, a list of connection properties is generated for the selected data source. Enter your connection credentials and save your changes on this page. Click Test Connection to make sure the app is connected to your data source.

Note: The application includes drivers for some common databases, but might not include drivers for all the data sources it supports. For drivers that are not included, make sure to follow the instructions below for your machine type.

Windows Edition

Install the ADO.NET provider on this machine, restart the server, and retry connecting to your data store.

Java Edition

Copy the JDBC driver to the lib folder of your Java Web server.