New Features - Application Integration - January & February 2024

Hi Community!

Our Engineering team for Application Integration and Connectors is continuing to roll out new features every week!  Here's a rundown on all the latest new features since Jan 1, 2024 till now (Feb 27, 2024) that you can take advantage of.  Please give us your feedback here in the community.  We especially love hearing from you on preview features that we are refining as they get ready for GA!

- Webhook Triggers using the Webhook Connector - Receive webhook events from your favorite application!

- New Data Transformer Functions to get the Integration version ID and number in the current execution!

- Custom Connectors [Preview] - We've referred to this as "BYOC - Bring Your Own Connector" in the past.  Create a connector in a few minutes from any OpenAPI 3.0 Spec!

- Cloud Logging Integration - You can now turn on Cloud Logging for any integration and the execution logs will also get sync'ed to Cloud Logging.  If you've been doing custom logging by calling out to the Cloud Logging REST API, you could consider just setting a variable that you create in every integration (like myCustomLoggerVar) to the value you want to log, and then turn on cloud logging.  Now your custom log information will sync to Cloud Logging automatically without another Rest Callout.

- Data Masking in logs [Preview] - You can mark any variable to be masked, and then the value will be masked with a pattern before being written to the execution logs/cloud logs.  This is great for protecting PII Data!  This is at the Variable granularity for now. If you only want to mask a few fields in the variable, but want to log the values from the rest of the fields, you can just create an additional logging variable that is not set as masked, and do a quick data mapping from the fields that you want to log...(try "REMOVE_PROPERY" mapping function to just delete the masked fields)  Then your desired fields will get logged, but the original masked variable will mask all the fields.

- Private Trigger [Preview] - This is a new type of trigger, which can only be called from another integration in the same project.  Private trigger invocations are not counted as an additional Integration Execution (Yay!), they increase security (these integrations cannot be triggered by anything external to the Integration project), and they improve performance by executing in the same processing thread, which saves on some execution startup latency

- Terraform support for creating new connections - Use terraform to automate the creation of connections in your environment build scripts

- VPC Service Controls for Integration Connectors [GA] - VPC Service Controls gives you the ability to block all egress from your cloud projects to prevent exfiltration of data.

- HTTP Connector supports OAuth 2.0 - Authorization Code grant type [GA]

- New GA Connectors [GA]  -
  - Acumatica
  - Amazon S3
  - Azure Data Lake
  - Couchbase
  - Dynamics 365
  - Elasticsearch
  - FTP
  - Magento
  - MySQL
  - Netsuite
  - PostgreSQL
  - SAP ERP
  - SAP HANA DB
  - Splunk
  - SendGrid
  - SharePoint
  - Workday
  - Xero
  - Zoho Books

New Connectors [Preview] - Check out all the new Google Connectors!
  - Cloud Natural Language
  - Firestore
  - Google Analytics
  - Google Calendar
  - Google Data Catalog
  - Google Docs
  - Google Drive
  - Google Forms
  - Google Tasks
  - Google Translate
  - Vertex AI
  - Webhook

- Custom SQL editor -  The custom SQL editor lets you run custom queries across different entities, and is available in the user interface of the following connectors:
  - BigQuery
  - Cloud Spanner
  - Cloud SQL for MySQL
  - Cloud SQL for PostgreSQL
  - Cloud SQL for SQL Server
  - Couchbase
  - Elasticsearch
  - MySQL
  - Oracle DB (Version 2)
  - PostgreSQL
  - Salesforce
  - Snowflake
  - SQL Server
  - Teradata

FYI, the following two connector versions will be deprecated on April 20, 2024. This is because we have much better versions available that you're going to want to use anyway! 
  - MongoDB (version 1)
  - Oracle DB (version 1)

2 1 327
1 REPLY 1

Roderick
Community Manager
Community Manager

Thanks for the update @shaaland!