Anaplan Connect to MS Access

Hi All,

I am trying to use Anaplan Connect to import data from MS Access table to Anaplan list. The table has only one column containing list values. I have created Anaplan import action based on text file with similar structure i.e. one column file.

I create jdbc.properties file as below

jdbc.connect.url= "Jdbc:Odbc:Driver={Microsoft Access Driver(*.mdb); DBQ=C:\Data\Anaplan\301 Anaplan Connect\Database1.mdb};"
jdbc.username=
jdbc.password=
jdbc.fetch.size=10
jdbc.isStoredProcedure=false
jdbc.query=” SELECT * FROM Table1”

Database1.mdb and Table1 are my access database and table name

I use this Operation in Anaplan bat file, where I put the name of the import action after -file, and location of the jdbc.properties after -jdbcproperties.

set Operation= -file "Prospects from Prospects.txt" -jdbcproperties "C:\Data\Anaplan\301 Anaplan Connect\anaplan-connect-1-3-3-5\jdbc.properties"

I downloaded MS Access JDBC driver for MS Access and copy the jar file and other extracted folder to Anaplan Connect folder. However, when I run the bat file, it gives message that it cannot find lib directory

Do I miss anything or set incorrect parameter in the .bat and jdbc.properties configuration?

Regards,

Andre

Accepted answers

All comments

Ernie_Goff

Andre -

Do you still need assistance with this?

If this is still an issue you may want to open a ticket with Anaplan Support on this to review the JDBC properties file syntax requirements.

I'm not an SME here, but based on a quick review of what you've provided, I'd test the notation of the 'jdbc.connect.url=' property. I'm not sure that what you have will work as you intend it to. You may want to start with the syntax from the example in the AC guide. Do you have a copy of that?

Best,

Ernie

andre.lie

Hi Ernie,

Thanks for the response.

My initial intention was to test Anaplan Connect with database. So, I used Access as I thought it was the easier one to test on my local. As there was problem with Access, I decided to test it using MySQL. The connection worked as I expected but I included the JDBC connection information in the Anaplan batch file instead of using a separate JDBC properties file. It still did not work with separate properties file though.

Here is the working set Operation in my batch file.

set Operation=-file "Anaplan_Demo_Sql" -jdbcurl "jdbc:mysql://localhost:3306" -jdbcuser "username:password" -jdbcquery "select distinct name from world.city where name <> 'San Miguel'" -import "SQL from Anaplan_Demo_Sql" -execute -output "C:\Data\Anaplan\301 Anaplan Connect\anaplan-connect-1-3-3-5\error.txt"

Regards

Andre

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385