- Introduction
-
Introduction to PostgreSQL Gateway
-
Introduction to PostgreSQL Gateway
- Create a user
-
Create user credentials
- Create a Data Factory in Azure
-
Create a Data Factory in Azure
-
Data Factory
-
Summary of creating a Data Factory
- Create a pipeline and add the source
-
Go into Azure Data Factory
-
Source
-
Learn more about data sources
-
Summary of adding a source
- Add the sink
-
Add the sink
-
Sink
-
Summary of adding the sink
- Create the mapping
-
Create the mapping
-
Mapping
-
Learn more about running pipelines
-
Summary of creating mapping
- Check the data
-
Check the data
-
Check the data in Cognite Data Fusion
- Summary
-
Check your knowledge
-
Key takeaways
-
Share your feedback
PostgreSQL Gateway
Get started with PostgreSQL gateway by using Azure Data Factory.
Welcome to the PostgreSQL Gateway course!
PostgreSQL gateway is a great tool to integrate a new data source that can be accessed through Azure Data Factory to Cognite Data Fusion. In this course, you will learn how to build your own extractor with PostgreSQL gateway with Azure Data Factory to build your own data pipeline.
By the end of this course, you’ll be able to:
- Explain when to use PostgreSQL gateway to integrate data into Cognite Data Fusion.
- Create a data factory in Azure.
- Add the source and the sink, which define the source you are reading data from and the destination of the data.
- Do the mapping between the source and the sink.
- Run the gateway and check that you have the data in Cognite Data Fusion.
Knowledge prerequisites
Basic experience using ETL tools (Azure data factory, Informatica Powercenter).
Basic knowledge of Postgres database.
Technical prerequisites
None.