Establish a Connection

Version 23.4.8839

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

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.