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 Amazon RDS into Elasticsearch, Elastic Cloud and Elastic Cloud Enterprise, surfacing it through BA Insight’s SmartHub to provide users with integrated search results.

Amazon RDSConnectors for Search Indexing

Organizations who leverage Amazon RDS can now extend the reach of this data into their existing search indexes via the BA Insight ConnectivityHub and our Amazon RDS Connector.

The key capabilities of the Amazon RDS Connector for Elasticsearch, Elastic Cloud, and Elastic Cloud Enterprise are:

  • Provides both full and incremental ingestion of content into the index of your choice
  • Provides all management of security, role, and access list management, requiring no specialized security software or search index add-ons
  • Supports all data stored within RDS
  • Supports filtering of the RDS content, allowing administrators to define specifically which data is sent for ingestion into the search index
  • Brings all associated metadata into the search index to drive refinement and relevancy
  • All content remains safely in RDS. The portal has only a searchable representation of data – pointers – and users are directed back to the URL/source application to launch data found in their search results.

The benefits of including Amazon RDS data within your Elasticsearch, Elastic Cloud, or Elastic Cloud Enterprise are:

  • Provides enhanced search capabilities into your existing search application while ensuring the source system retains the master information
  • Indexes with a very high throughput
  • Requires no custom code, with full support and enhancements

Future-proof Your Investment

As new versions of Elasticsearch, Elastic Cloud, and Elastic Cloud Enterprise are released, new features and functionality are introduced. BA Insight takes on the burden of keeping the connector up to date for both RDS and the Elastic search engine. 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.

Drive Productivity

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