What is application integration?
Application Integration is an Integration-Platform-as-a-Service (iPaaS) solution offered by Google Cloud. It encompasses a broad range of essential integration tools designed to connect multiple applications seamlessly. This service is fully managed by Google, operates in a serverless manner, and automatically scales to meet your needs. Together with its intuitive drag-and-drop user interface, it becomes a robust tool for effortlessly building, overseeing and expanding integrations on Google’s highly scalable infrastructure.
Use case: application integration for custom message tracking.
In the following use case, the objective is to customise tracking of messages sent to a certain Pub/Sub topic. You accomplish this by creating an integration that listens to this Pub/Sub topic and behaves depending on the received message. To increase the ease of use, you will facilitate access of tracking data through a tool like Google Sheets. With the aid of application integration, you can establish this behaviour in a scalable way, while keeping the implementation relatively simple. The integration used for this use case is shown in the figure below.
Setting up authentication: in order for the integration to possess the correct access privileges, you need to set up an authentication profile using a service account in the authentication profile tab. To give it access to the Google Sheets API you need to add “https://www.googleapis.com/auth/spreadsheets” to the scope of the profile. The service account does not need any other roles/privileges whatsoever. The settings of the authentication profile can be seen in the figure below. To give the profile access to your Google Sheet, you must grant ‘Editor’ rights to the service account’s email address on your sheet. This authentication profile will also be referred to in the Sheets – Append task.
Sending data to Google Sheets: for the sheets API to work properly, the row data needs to be accompanied by some static metadata. To attach this metadata, you can create a local variable inside the integration context with the static data as the default value. You can then use the Data Mapping task to combine the processed Pub/Sub message with the local variable using the “MERGE” function. The task schema can be seen in the figure below. The combined data packet can then be sent as a request to the Google Sheets API using the Sheets Append task. For the Sheets Append task, the authentication profile created in the last step needs to be referred to as this account has access to your sheet.
Adding more custom behaviour: sending mails on certain Pub/Sub messages
Why you should use application integration
Application Integration sets itself apart by having a user-friendly interface and capabilities to quickly create an integration that connects different applications. Next to this you can also easily modify and extend the behaviour of the integration. Setting up custom integrations where different applications communicate with each other can often become very complex for even the simplest use cases. With the usage of Google Cloud’s application integration, these implementations become much more simple, which can help development teams become more efficient and agile.
Other use cases that can serve as a source of inspiration.