Microsoft SQL Server is the industry leading Operational Database Management System. Gartner recognized Microsoft as a Leader once again in the Magic Quadrant for Operational Database Management Systems, positioning it furthest to the right on the axis for completeness of vision, and closest to the top on the axis for ability to execute.
Organizations leverage SQL Server to solve a wide range of complex business problems, and the data stored within these specific databases often goes unnoticed in the intranet or search portal platform. The BA Insight SQL Server Connector allows organizations to tap into the wealth of data stored within SQL databases, making that data instantly actionable to users through search.
The SQL Server Connector is built upon industry standard database access methods, so it can equally support databases from other systems such as Oracle, MySQL, and IBM DB2. It honors the security of the source database and provides both full and incremental crawls so the users have the latest information available to them all the time.
The SQL Server Connector for SharePoint is standard, off the shelf software that addresses the following requirements:
1Works with all types of data.
2Works with custom tables, documents, attachments, and BLOB data.
3Indexes every desired item with a very high throughput. Many SQL databases have millions of rows, making high throughput critical to the success of the implementation.
4Minimizes the impact on the source system through views or stored procedures as necessary, ensuring no impact to its performance.
5Only surfaces the content that users are permitted to see, even if the security configuration is custom designed.
6The source system retains the master information and the search index has only a representation (pointers). If applicable to the database being crawled, users click on a search result and are taken to their original item or document.
Future-proof your investment for new SharePoint versions and O365
With each successive version of SharePoint, Microsoft extends its core capabilities, and the same is true of new releases of the SQL Server. BA Insight does the hard work of keeping the connector up to date for both SQL Server and SharePoint, including support for SQL Server 2016. In addition, the SQL Server Connector also supports O365 through Cloud SSA and current versions of SharePoint on-premise including 2010, 2013, and 2016.
The upgrades are easy to do and can be done by your IT organization. It is a matter of accessing the BA Insight customer portal, downloading the latest release and installing and configuring it. Or, if desired, our professional services team can handle the upgrades.
Drive Organizational Productivity
By connecting SQL Server databases to SharePoint, you increase adoption of your intranet, improving organizational efficiency and productivity.