BA Insight's Amazon RDS connector for search honors the security of the source system and provides both full and incremental crawls so the users have the latest information available to them all the time.

Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while automating time-consuming administration tasks such as hardware provisioning, database setup, patching and backups. It frees you to focus on your applications so you can give them the fast performance, high availability, security and compatibility they need.

Amazon RDS is available on several database instance types - optimized for memory, performance or I/O - and provides you with six familiar database engines to choose from, including Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle, and Microsoft SQL Server. You can use the AWS Database Migration Service to easily migrate or replicate your existing databases to Amazon RDS.

BA Insight’s Amazon RDS 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 indexes content from multiple search engines, surfacing it through BA Insight’s SmartHub to provide users with integrated search results.

Amazon RDSConnectors for Search Indexing

The Amazon RDS Connector honors the security of the source database and provides both full and incremental crawls so that users have the latest information available to them at all times.

Our Amazon RDS Connector is standard, off-the-shelf software that addresses the following requirements:

  • Works with all types of data.
  • Works with custom tables, documents, attachments, and BLOB data.
  • Indexes 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.
  • Minimizes the impact on the source system through views or stored procedures as necessary, ensuring no impact to its performance.
  • Only surfaces the content that users are permitted to see, even if the security configuration is custom designed.
  • The 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

As new versions of the search platforms are released, new features and functionality are introduced, and the same is true of new releases of Amazon RDS. BA Insight takes on the burden of keeping the connector up to date for both Amazon RDS and the respective search engines. 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.

Platforms Supported:

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

Drive Organizational Productivity

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