Announcement: Application Integration & Integration Connectors - Preview

[Former Community Member]

Hello! 

We’d love to invite you to try the Application Integration Preview. Application Integration is an Integration-Platform-as-a-Service (iPaaS) solution by Google Cloud that offers a comprehensive set of core integration tools to connect and manage the multitude of applications and data required to support various business operations.

Application Integration provides a unified integration designer with out-of-the-box triggers, custom-configurable tasks, and pre-built connectors. The integration designer is a drag-and-drop interface that lets you create your entire integration flow with little or no code. You can create, modify, and run all your integrations in the integration designer.

With Application Integration, you can:

• Create long-running processes triggered by a variety of source data inputs.
• Invoke integrations in response to external events or on a customized schedule.
• Access and transform data payloads between applications into meaningful schema.

Application Integration Preview is equipped with the pre-built connectors to enable you to configure and integrate with:

• Applications: Salesforce, SAP, BigCommerce, Jira Cloud, Twilio, Workday, Zendesk, ServiceNow, Active Directory, Box, Elasticsearch, Email, LDAP, Dynamics NAV, PayPal, Splunk
• Databases: MySQL, Apache Cassandra, Apache Kafka, Apache CouchDB, BigQuery, CockroachDB, MariaDB, MongoDB, Oracle DB, PostgreSQL, Redis, SQL Server, SFTP
• Google Cloud services: Pub/Sub, Cloud Spanner, Cloud SQL - MySQL, Cloud SQL - PostgreSQL, Cloud SQL - SQL Server

If you are interested in participating in the public preview, please try the Application Integration Preview.

We’d love your feedback on your experience with Application Integration to continue building the best integration product. Please share your thoughts and feedback with us

[thenajjar]

We are trying to integrate our backend with third party application, we are not sure how can we call the API_trigger? how can we link the API_trigger to a REST API endpoint. In the documentation it only explains how to test the API_trigger, but it does not explain how to edit the API_trigger to link it to an endpoint (so the API call will activate the trigger)

[Former Community Member]

Can you please post this as a new question in the future? It will be useful for others too. I will copy the contents and reply there.

[kadvani]

hello ,

I am working on a use case to integrate IBM MQ in our data center with Cloud Storage in GCP. I understand the IBM MQ connector available in Google Cloud supports "sendMessage" action ( i.e writing a message to a queue in IBM MQ ) ?. Does the IBM MQ connector support reading of the messages from IBM MQ as well ?. Can you share weblinks as to how can this integration be made possible leveraging Application Integration service in GCP. Thank you 

[Former Community Member]

Thanks for the question @kadvani. It is best to create new topics for new questions.

How were you planning to use MQGET? Were you thinking about triggering integrations when a message lands on a queue or was it a case where in the middle of an integration you want to read a message by message id (or correlation id)?

[kadvani]

That is right @Former Community Member  . I need to set up the trigger within the connector task in such a way that when the message lands in the queue in IBM MQ , the connector reads the message and transfer it into a GCS bucket .  The idea to have be able to  process the messages being placed in IBM MQ in real-time . Is this integration doable using IBM MQ Connector ?.

[Former Community Member]

Understood. That is not possible at the moment. Supporting a trigger for IBM MQ is on the roadmap.

[kadvani]

Thank you for the update @Former Community Member . this helps . do we know what time frame are we looking at on when the IBM MQ trigger functionality might be made available for preview ?. please advise .

[Former Community Member]

We don't publish our timelines and details of our roadmap publicly. If you are working with a GCP sales rep, we can share material under a NDA. Otherwise I request subscribing to this channel and we will publish updates here.

[kadvani]

our company uses the Google Cloud Platform to run our IT workloads in the cloud  and we work closely with the Google team for migrating our workflows from the data center to the cloud using gcp-native tools. Do you need the google resource name whom i am working with in order for you to share the material pertaining to IBM MQ connector . Please let me know .

[kadvani]

question for you @Former Community Member , can i use the pubsub integration connector to read the messages from the IBM MQ into a pubsub topic , considering i have the required firewall ports between the IBM MQ server and GCP ?. please advise. if that is doable , i can build a pipeline to read the message from pubsub topic into the gcs bucket . let me know your thoughts on this integration ?

[kadvani]

Thank you @Former Community Member  .One point I wanted to clarify regarding using the Schedule Trigger to read from IBM MQ and write to GCS bucket.

Where can I define the schedule trigger within Application Integration to read from MQ ?. or is this something I will need to handle outside of GCP  ?

The idea is to have some way for reading the messages from MQ and writing them to PubSub queue /  GCS bucket  .

Can you help clarify ?

[Former Community Member]

The ability to simply read from a queue (MQGET) is not available at the moment. This is also on the roadmap.

[joealbanese]

Is there a way to connect to an FTP server that is on private address space?

[Former Community Member]

I request you please create a new thread. This thread was meant for the announcement.

To answer your question, yes. Through PSC. You'd have to expose the FTP server through an L4 ILB and create a service attachment for it.

[nicmansson]

@Former Community Member I've been able to successfully hookup to a Workday tenant using the WD Connector and tried both the Human_Resources and Financial_Management Services but I'm not getting any entities or actions in return when trying to use it, and wasn't able to find any documentation on how to specifically use the WD Connector, just how to configure the setup portion. Any insight or guidance you can provide?

[Former Community Member]

@nicmansson - can you please start a new thread for the workday connector? It will be easier for us to address your concerns there.

[sudershan1903]

 Hi @Former Community Member ! I have a use-case where I need to pass an input parameter(partyName) to my Integration flow which has an API trigger (SendResultEmail_API_1). I have the below CURL command to test the integration from Cloud shell.

curl -X POST -H "authorization: Bearer $(gcloud auth print-access-token)" -H "Content-Type: application/json" -d '{"trigger_id":"api_trigger/SendResultEmail_API_1", "partyName":"sample-name-1"}' "https://asia-east1-integrations.googleapis.com/v1/projects/<project-id>/locations/-/integrations/-:execute"

The variable partyName is defined as an input variable in the Integration. 

When I run the above command, I am seeing the error below - 

When I run the command without the input parameter value, I'm able to get the response from Integration. I'm assuming the issue is with the way I'm passing the value as input for the Integration.

Would be great if you could share a sample payload for the input for the Integration, also your comments on any issues with the command

[Former Community Member]

@sudershan1903 can you please start a new thread? This thread is reserved for the announcement only.

[Chris1987]

Hello!

Do we know what connectors are in the roadmap?

Thanks,

Chris

[Former Community Member]

We do not publish our roadmaps outside a NDA or in public.