Anaplan Connect User Guide

• Introduction to Anaplan Connect
  • What is it for?
• To Install Anaplan Connect
• Supported authentication methods
  • Username and password based authentication
  • Certificate-based authentication
• To import a text file and run the import
  • First run the import manually
  • Then copy and edit a Batch file to automate this process
• Where to find the variables to use in the batch file
  • AnaplanUser
  • Workspace ID, Model ID
  • -file
  • -put
  • -import
  • -execute
  • -output
• List of Available Operations
• JDBC Operations
  • Example: Upload a file, but do not run the import
  • Example: Run the import from a pre-loaded file
  • Example: Upload 2 files and run 2 imports
  • Example: List workspaces using certificate-based authentication
  • Example: Export data to a text file or Excel file
    • First run the export manually
    • Then edit and run the batch file
  • Example: Run the export, but do not download
  • Example: Download the results from an export that has already been run
  • Example: Running a model to model import
    • First run the import manually
    • Then edit and run the batch file
  • Example: Deleting Items from a List
  • Passing run-time parameters
  • To schedule an import or export
    • Scheduler for Windows XP
    • Scheduler for Windows 7
• JDBC Connectivity
  • SQL statement examples
  • Example: Loading from MySQL databases
  • Example: Load a table from an Access Database into Anaplan
  • Example: Load an Excel Spreadsheet into Anaplan
• FAQ
  • What about Mac users, Linux and Unix operating systems?
  • Example of a .sh file for use on a Mac
  • Can “.zip” files be used to speed up the upload ?
  • Can the source file name be changed, yet still use the same import definition?
  • Can relative rather than absolute paths be used for the source file?
  • Is it possible to close the window after running a Windows batch file?
  • Is it possible to list the available import definitions, actions, files, models etc ?
  • Anaplan Connect batch file does not run successfully. Why not?
  • Where does Anaplan Connect run Java from?
  • Why cannot Anaplan Connect communicate with the Anaplan servers when my browser can?
  • Why do I get a “HTTP status 407: Proxy Authentication Required” message?