AnsweredAssumed Answered

Is Canvas Data compatible with Oracle?

Question asked by Glen Parker on May 20, 2016
Latest reply on May 20, 2016 by Glen Parker


I ask, because I've been trying to convert existing scripts to load data into Oracle, and I've run into a number of potential show stoppers.

 

1)   Identifiers longer than 30 characters.

The Table  quiz_submission_historical_fact  is 31 characters long

The Column quiz_question_answer_dim.matching_answer_incorrect_match is 31 characters long

 

Both of these exceed Oracle limits on Identifiers of 30 characters.   My understanding is that I can only truncate these identifiers, and then will have to update any future code I write or share with others to keep this truncation in mind.

 

2)  quiz_submission_historical_fact.date used as a column name

  date is a reserved keyword.    I can quote the column name ("date") , but omg this is such bad form.   Again, I'll have to remember to quote the column name henceforth in anything I share .

 

I'm still picking through setting up the schema.   Anyone else gotten this working with Oracle, any more surprised lurking in store?

 

 

Thanks, Glen

Outcomes