Establish a Connection
Version 24.2.9039
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.