Automic Automation / Google Cloud BigQuery Agent Integration

Google Cloud BigQuery is a cloud-native, fully managed, highly scalable big data warehouse equipped with a powerful built-in query engine. It separates the engine that analyzes your data from your storage choices, thus maximizing flexibility and allowing you to either store and analyze your data within BigQuery, or to use BigQuery to analyze your data where it lives.

The Data Transfer Service automates data movement into BigQuery. Once you have configured a data transfer, this service automatically loads data into BigQuery on a regular basis.

Integrating Automic Automation with Google Cloud BigQuery allows you to start a Transfer Configuration pipeline from Automic Automation to bring data into your BigQuery system from different sources.

The Agents and the Automation Engine communicate using TLS/SSL, which requires using trusted certificates to prove the identity of the respective communication partner.

When an Agent communicates with an on-premises Automic Automation system, it establishes the connection to the Java communication process (JCP). When communicating with the Automic Automation Kubernetes Edition, it established the connection to an ingress / HTTPS load balancer. Regardless of the environment you use, you have to make sure that you have the required certificates in place.

Important!

Make sure you are familiar with the TLS/SSL and certificate implementation before installing and/or upgrading the respective component. For more information, see the Automic Automation documentation at:

Note:

This integration capability, like all integrations of the Automic system, can support service orchestration Workflows. Such Workflows orchestrate automated processes that run across multiple platforms, domains, and applications to deliver a specific IT service. For more information, see About Service Orchestration in the Automic Automation help, which is available on docs.automic.com.

Release Cycles

The release cycles of this Agent Integration are independent of the Automic Automation ones.

For more information, see Compatibility Information.

Important Consideration

To implement (install and configure) and work with the Google Cloud BigQuery Agent Integration (configure Run Pipeline Jobs and include them in other Automic Automation objects), a sound knowledge of Automic Automation is required.

If you are new to Automic Automation, we strongly recommend that you take the following courses before beginning with this integration:

For all users:

For administrators:

For developers and object designers

This documentation describes how to set up the integration and how to work with Google Cloud BigQuery jobs.