Create an External Connection to an API

Use the External Connection Wizard to create and manage External Connections. External Connections can be created with the following types of APIs that provide access to a range of data sources:

  • MySQL or SQL Server
  • Oracle
  • ODBC: Used for many sources, including file formats like Excel files, Access databases, .txt files, and more.

    The ODBC Providers list might vary depending on the drivers installed.

  • OLE DB: This is the newer version of ODBC and is used for both relational and non-relational databases (SQL, Oracle, Excel, raw files, etc.)