Product

Easily integrate data from MySQL, Elasticsearch, or Google Analytics with Algolia’s latest no-code connectors
facebooklinkedintwittermail

Does the phrase “data integration” fill you with dread? The integration process can be frustrating and time-consuming. Algolia’s connectors simplify the integration workflow, making data easily accessible. With our no-code data connectors, both technical and non-technical users can pull data from key sources to use with Algolia – all through a single dashboard.

Access data connectors through the Algolia dashboard.

With our connectors your team can take advantage of Algolia’s superior search capabilities quickly and with minimal effort –  allowing your team to focus on value creation, rather than grappling with data integration headaches.

Three new database connectors to the dashboard

We have three additions to our connector platform, making it even easier to import your data to work with Algolia’s top of the line search capabilities.

  • MySQL connector: Import any MySQL table into Algolia with continuous syncing
  • Elasticsearch connector: Take advantage of Algolia’s superior search capabilities and migrate your Elasticsearch data to Algolia with minimal effort.
  • Google Analytics 4 event connector (β): easily connect to a BigQuery table and export GA event data to power Algolia’s tools such as AI Personalization and Recommend.

How to connect your data

To integrate your data, you’ll need an active Algolia account and access to your data source.

Click on “Data sources” from the homepage of the Algolia dashboard to go to Algolia’s Datahub and view the available connectors.

Each of the connector’s workflow follows three easy steps:

  1. connect the source
  2. create a destination
  3. configure the data integration task.

For example, when building an index from a MySQL database. First, create a new source and enter your connection details to grant Algolia access to your MySQL database. A popup will confirm if the new source is set up successfully and connectivity is established.

Next, create the destination for your source data – either an existing or new index. To make things easier, credentials for the destination can automatically be generated.

Finally, configure the task, which includes defining a schedule for fetching data and choosing to fully replace, partially update, or append data to an existing index.

Algolia’s MySQL connector

Advanced connector capabilities

We’ve added new functionality to our connectors for greater flexibility and control over your data.

  • Advanced security settings
    When connecting your source, SSL connections is the preferred method and enabled by default. For those needing an extra layer of security, we support other connection modes such as the SSH tunnel method.
  • Change data capture (coming soon)
    To reduce load time, users now have the option to make incremental updates rather than a full refresh.
  • Create a transformation feature
    The new data transformation feature lets users write transformation functions in JavaScript as part of the data integration process to perform basic data manipulations such as change a data type, filter out a subset of records, remove a property, group values or attributes.
  • Synchronize tables and columns
    Currently the latest workflow feature lets you select which tables to synchronize. Synchronizing columns will be added soon.

Connect your data and start optimizing search

We remove the friction and frustration of data integration so you can get up and running faster with our search and discovery capabilities – regardless of your technical skill.

To see how to quickly get started with our latest no-code data connectors, watch the Algolia DevBit video.

Or visit the Algolia Developer Hub.

About the authorJoni Khattar

Joni Khattar

Senior Product Manager @ Algolia

Recommended Articles

Powered by Algolia AI Recommendations

Introducing the new Algolia no-code data connector platform
Engineering

Introducing the new Algolia no-code data connector platform

Keshia Rose

Keshia Rose

Staff Product Manager, Data Connectivity
Can an Elasticsearch alternative stack up?
Product

Can an Elasticsearch alternative stack up?

Louise Vollaire

Louise Vollaire

Product Marketing Manager
How and why events drive search ROI
Product

How and why events drive search ROI

Jaden Baptista

Jaden Baptista

Technical Writer
Ben Franz

Ben Franz

Sales Engineering and Product Leader at Algolia