Analytics Software

Hi All:

I am trying to load a csv file to Planning Account dimension using ODI. I have reviewed blogs/instructions/documentations and tried to go back and look at various setups but to no avail.

So here's my steps:

1) Setup connection details for CSV & Planning in Topology manager;
2) Import KM modules for Planning;
3) Setup 2 Models, 1 for CSV & 1 for Planning;
4) Setup an interface to link csv to planning. It's pretty straight forward csv file and I did use the Sunopsis Memory Engine as staging area to match the column header to DIM properties.

Here's what I seeing:
1) I was able to successfully reversed engineer Planning table
2) I was able to see my csv file column correctly after the csv model setup
3) all interface diagram looks correct

The problem:
When I ran the interface, the error occured on step 3 (Loading SS_0 Load data). The first step has a warning (Drop work table) stating that there's no table to be dropped but it continues to the next step just fine. Here's the error:

08001 : java.sql.SQLException: No suitable driver
java.sql.SQLException: No suitable driver

at java.sql.DriverManager.getDriver(Unknown Source)

at com.sunopsis.sql.SnpsConnection.u(SnpsConnection.java)

at com.sunopsis.sql.SnpsConnection.c(SnpsConnection.java)

at com.sunopsis.sql.i.run(i.java)

I am not sure where I did wrong at this point. Is this a corrupted driver for Sunopsis staging table that's causing this problem? Any helps would be very much appreciated.

Also, has anyone tried using ODI on an EPMA app successfully yet? I have heard once you convert the classic to EPMA you won't be able to use ODI, is it true?

Thaks all!

Mike