Anaplan Connect is a downloadable tool that empowers you to automate Anaplan actions. This lightweight tool still relies on the same types of flat files that can be manually uploaded into Anaplan. Once this tool is installed on your computer, you can package that point-and-click process in a script (.bat or .sh files). These scripts work well with external scheduling tools, enabling you to schedule and automate a data upload/download from Anaplan's cloud platform.

Most often, Anaplan Connect is used in conjunction with flat files, but it can also be used to connect to any relational database with JDBC.

 

JDBC

JDBC stands for Java Database Connectivity. It is the industry standard API for database-independent connectivity between Java and a wide range of SQL databases, as well as other tabular data sources. A JDBC connection relies on Anaplan Connect to handle the Anaplan side of the integration; it has a separate category because this is the only type of Anaplan Connect script that will contain an SQL query.

As with any non-JDBC integration using Anaplan Connect, Anaplan must already have a template file stored as a data source. As long as this data source is available within the Anaplan model, a JDBC integration differs from a flat file Anaplan Connect script when it comes to selecting the file for import. With a JDBC integration, this is the result of an SQL query instead of the location of a flat file. The results of this query are passed directly to Anaplan without needing to store a file.

Learn more about Anaplan Connect and download the Anaplan Connect Quick Start Guide in Anapedia.

Comments

The Anaplan Connection with DELL represents a single connection with Single Anaplan Account. If you want to use multiple Connections you can use separate accounts for each. You can pair this connection with different Anaplan operations to perform a unique action against an Anaplan instance.

Latest Articles
Hub Model Hierarchy Management
On-Demand Courses
3 weeks ago
HyperConnect
On-Demand Courses
3 weeks ago
Effective Dating
On-Demand Courses
3 weeks ago
Automating User Access
On-Demand Courses
3 weeks ago
Selective Access Overview
On-Demand Courses
3 weeks ago
Labels (2)
0 Kudos