Anaplan API : Could not connect to database!

Hello,

I'm following the Data Integration Training - Part 2 on how to use Anaplan Connect to import data from a relational database. The training suggests an access database named Employees.mdb. Upon execution, I encountered an error (please refer to the screenshot attached).

Any help will be highly appreciated. Thank you in advance for your input,

Accepted answers

All comments

ben_speight

What does jdbc-query-emlployees.properties contain? The error suggests a mismatch between the number of parameters in jdbc.params and the number of '?' placeholders in jdbc.query.

Quick Links

Can you help?

Unanswered questions

Azure SQL Connection, database name with Hyphens in Data Orchestrator
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…