How to create an Azure Cognitive Search index and indexer with PostgreSQL DB data source

Question

Is there a way to create an Azure Cognitive Search index and indexer with a PostgreSQL DB data source?

I've worked with both Azure SQL database and Azure Blob Storage data sources before, but I now need to directly connect to the PostgreSQL database, which I am not sure how to do.

And if it is possible, will the indexer also be able to auto-refresh the updates in the index (without additional steps) when changes to data are made on the PostgreSQL table?

Thanks.

Answer 1

Hi @Christine Kim thanks for the question. Currently, Azure Cognitive Search does not natively support PostgreSQL as a data source for creating an index and indexer

However there is a workaround which was shared on this Stack Overflow: "You can use an Azure Data Factory pipeline that supports PostgreSQL as source and use a staged storage account, then you can create a Blob indexer or use an Azure Cognitive Search index sink.

In this temporary documentation link you can find how to set the Azure Data Factory pipeline for this integration."

Hope that helps.

Best,

Grace