Following recent announcements on the global strategic partnership between Anaplan and Google Cloud, we are pleased to unveil a new connector.
Now, users can leverage Anaplan Connect for bi-directional integrations with Google BigQuery. This free connector makes integrations between Anaplan models and Google BigQuery via Java Database Connectivity (JDBC) drivers that leverage the power of BigQuery's standard SQL.
Users can easily pull any data from BigQuery—such as actuals, transactions, lists, and hierarchies—straight into Anaplan models for faster planning, modeling, and analysis. In addition, users can easily push any data from their Anaplan models back to BigQuery to easily share the results of the planning process to all users leveraging BigQuery for operational and reporting processes.
The JDBC driver is publicly available and can be downloaded with Anaplan Connect for free from the Google website.
To get started with the JDBC driver, users should be familiar with Anaplan Connect. Learn more about Anaplan Connect and how it works.
Next, follow the step-by-step instructions below that detail how to download, install, and configure the Simba JDBC driver for Google BigQuery with Anaplan Connect.
Should you encounter any issues, please contact Anaplan Support. Our Support team will work and partner with Google to resolve any issues.
Note: Refer to google documentation on how to obtain values for ProjectId, OAuthServiceAcctEmail, and OAuthPvtKeyPath.
Refer to Simba JDBC Driver for Google BigQuery Install and Configuration Guide.pdf for additional information on Simba JDBC Driver for BigQuery.
Find additional information using Google Service Account for authentication.
Note: Simba documentation versioning can sometimes differ from the version of the driver Google is distributing.
Find steps to create a service account and generate a private key for OAuth 2.0.