Google Cloud SQL Database Connector

Google Cloud SQL Database Ingestion Connector for Elasticsearch, Elastic Cloud, and Elastic Cloud Enterprise

Google Cloud SQL is a fully-managed database service that makes it easy to set up, maintain, manage, and administer your relational PostgreSQL and MySQL databases in the cloud. Cloud SQL offers high performance, scalability, and convenience. Hosted on the Google Cloud Platform, Cloud SQL provides a database infrastructure for applications running anywhere.

Let Google manage your database so that you can focus on your applications. Cloud SQL is perfect for WordPress sites, e-commerce applications, CRM tools, geospatial applications, and any other application that is compatible with MySQL or PostgreSQL.

Cloud SQL is easy to use. It doesn't require any software installation. It automates all your backups, replication, patches, and updates - while ensuring greater than 99.95% availability, anywhere in the world.

The Google Cloud SQL Connector indexes content from Google Cloud SQL into Elasticsearch, Elastic Cloud, and Elastic Cloud Enterprise, surfacing it through BA Insight’s SmartHub to provide users with integrated search results.

Google Cloud SQL Connectors for Elasticsearch

The Google Cloud SQL Connector honors the security of source database, and provides both full and incremental ingestion so the users have the latest information available to them all the time.

The key capabilities of the Google Cloud SQL Connector for Elasticsearch, Elastic Cloud, and Elastic Cloud Enterprise are:

  • 1

    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.

  • 2

    Minimizes the impact on the source system through views or stored procedures as necessary, ensuring no impact to its performance.

  • 3

    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.

  • 4

    Only surfaces the content that users are permitted to see, even if the security configuration is custom designed.

  • 5

    Google Cloud SQL retains the master information and the search index has only a representation (pointers). If applicable to the database being indexed, users click on a search result and are taken to their original item or document.

The benefits of including Google Cloud SQL data within your Elasticsearch, Elastic Cloud, or Elastic Cloud Enterprise are:

  • 1

    Provides enhanced search capabilities into your existing search application while ensuring Google Cloud SQL retains the master information

  • 2

    Increases adoption of Google Cloud SQL via direct links back into Google Cloud SQL to any content found by a user

  • 3

    Ingests data with a very high throughput

  • 4

    Has minimal impact of the source system, even helping to improve source system performance by offloading taxing search features

  • 5

    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, and the same is true of new releases of Google Cloud SQL. BA Insight takes on the burden of keeping the connector up to date for both Google Cloud SQL 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 Organizational Productivity

By connecting Google Cloud SQL databases to your Elastic search engine, you increase adoption of your intranet, improving organizational efficiency and productivity.