SQL Connector Prerequisites

Note! The BA Insight SQL connector is embedded into Connectivity Hub and Connector Framework.

The connector requires only the following user account and application prerequisites:

Administrator Prerequisites

This section assumes the reader has considerable knowledge and experience in the configuration and administration of the following:

Required Permission	Description
Database Application	For OLEDB data sources, like Oracle, the appropriate OLEDB driver is installed for your database READ access to your database and a valid login.
Azure AD An identity and access management solution from Microsoft that helps organizations secure and manage identities for hybrid and multicloud environments. Authentication	BA Insight does NOT support Azure AD A directory service for Windows domain networks. A hierarchical structure that stores information about objects on the network. Used to manage permissions and control access to critical network resources. authentication with Azure SQL. The user account used to connect to Azure SQL must be a SQL account.
Azure AD Users and Groups	If Azure AD users and groups are used to secure database records, contact BA Insight to confirm your environment is compatible.

Features	Supported	Additional Information
Application version
Searchable content types	Yes	All types.
Content Update	Full and Incremental	All BA Insight Connectors support both Full and Incremental crawls, unless noted.
Permission Types	Yes	All BA Insight Connectors support fetch ACLs from the source system Your Source System is the repository where your data is stored (data to be indexed). This repository is managed by applications such as: - SharePoint O365 - SharePoint 2013/16/19 - Documentum - File Share - OpenText - Lotus Notes - etc. Your Source System repository can also be a database such as SQL or Oracle.. To make items *public* or *restricted* to a single user/set of users, you can do so within the Connector Framework.
Required Software	.NET Framework v4.7.2