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.
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