Hello,
Have you copied over your Oracle thin JDBC driver zip file from the lib directory of your 1.3 installation?
Some precisions:
We have error with :
set Operation=-debug -auth %AuthLocation% -loadclass %OracleDriver% -file %FILE_01_STAGE% -jdbcproperties %JDBCPROPERTIES% -import %IMPORT_01_STAGE% -execute -output %FILEERROR_01_STAGE%
And when we remove the -File :
set Operation=-debug -auth %AuthLocation% -loadclass %OracleDriver% -jdbcproperties %JDBCPROPERTIES% -import %IMPORT_01_STAGE% -execute -output %FILEERROR_01_STAGE%
Is the %OracleDriver% variable set earlier in the script? It should probably be oracle.jdbc.OracleDriver.
The lib folder only has the following files in a clean install:bcprov-jdk15on-164.jarInstallBouncyCastle.batInstallBouncyCastle.shREADME.mdYou only need to copy over the Oracle JDBC driver jar(s), not the others.
Yes, Variable is defined in the script
set OracleDriver="oracle.jdbc.driver.OracleDriver"
The lib folder is now clean but we have always the same error message Anaplan API: Could not connect to database! (SQL: No suitable driver found for "jdbc:oracle:thin:server_name:port:database"
ojdbc6_g.jar is just a variant of ojdbc6.jar with debug logging capabilities. Unless you want to trace the SQL queries (and know how to configure the logging) you probably don't need it, and only one of the two is required.
If you have -loadclass oracle.jdbc.driver.OracleDriver (or oracle.jdbc.OracleDriver) on the command line, then the driver should be registered when you use a jdbc:oracle:thin:... connection string, but the "no suitable driver found" error suggests this is not the case. Another way of registering the driver is to
set JAVA_OPTS=-Djdbc.drivers=oracle.jdbc.driver.OracleDriver
I'm assuming the remainder of your actual connection string is different, and you've also omitted the -service, -workspace and -model parameters.
Thanks a lot for your advice.
We found solution. The problem came from " " placed on the sql request in the jdbc.properties
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
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.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…