MySQL is an open-source relational database management system (RDBMS).

In July 2013, it was the world's second most widely used RDBMS, and the most widely used open-source client–server model RDBMS. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.  For proprietary use, several paid editions are available, and offer additional functionality.

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open-source web application software stack (and other "AMP" stacks). LAMP is an acronym for "Linux, Apache, MySQL, Perl/PHP/Python". Free-software open-source projects that require a full-featured database management system often use MySQL.  Applications that use the MySQL database include: TYPO3, MODx, Joomla, WordPress, phpBB, MyBB, Drupal and other software. MySQL is also used in many high-profile, large-scale websites, including Google (though not for searches), Facebook, Twitter, Flickr, and YouTube.

MySQL Connectors for SharePoint

In addition to MySQL, other database connectors we provide include Oracle, Microsoft SQL Server, and IBM DB2

Our MySQL Connector:

  • Honors the security of source database/application, only surfacing information that users are permitted to see.
  • Provides both full and incremental crawls so the users have the latest information available to them all the time.
  • The source system retains the master information and the search index uses pointers to the original items. After the MySQL database is crawled, the users click on a search result and are taken to their original item or document.
  • Works with all types of data including custom tables, documents, attachments, TEXT, and BLOB data.
  • Indexes with a very high throughput. Many MySQL databases have millions of rows, making high throughput critical to the success of the implementation.

Future-proof Your Investment

As new versions of the search platform are released, new features and functionality are introduced, and the same is true of new releases of MySQL. BA Insight takes on the burden of keeping the connector up to date for both MySQL and the respective search engines. The upgrades are easy to do and can be done by your IT organization. It is simply a matter of accessing the BA Insight customer portal, downloading the latest release, and installing and configuring it. If desired, our professional services team can handle the upgrades.

Platforms Supported:

  • Amazon Kendra
  • Amazon OpenSearch Service
  • Azure Cognitive Search
  • Elasticsearch
  • Microsoft Search
  • SharePoint Online
  • SharePoint On-Premise
  • Solr

Drive Productivity

By connecting MySQL to your preferred search engine, you increase adoption of your intranet, improving organizational efficiency and productivity.