SQL & ODBC data source
Data Manager is included in all Service Collection Premium and Enterprise plans.
The SQL & ODBC data source is a general data source for bringing data from SQL (Structured Query Language) and ODBC (Open Database Connectivity) databases into Data Manager.
This task requires Data Manager & Adapters admin permissions to complete. See how permissions and roles work in Data Manager.
The data source allows you to connect to external databases, run queries, and load the results into Data Manager as raw data. To configure and use the SQL & ODBC Adapter, you create a database job that specifies:
the database connection details (server, database, authentication)
the query or stored procedure to run
the destination table in the Data Manager staging database
この内容はお役に立ちましたか?