350 likes | 520 Views
DROA, Connections and Gotchas from DOTA to InfoView. NWDUG 2012 Eric Matchett Clackamas Community College 503-594-0758. Data path from colleague to infoview. Transforms in Datatel DORE Export and Stored Procedure ODS and SQLServer Business Objects Universe Designer InfoView
E N D
DROA, Connections and Gotchas from DOTA to InfoView NWDUG 2012 Eric Matchett Clackamas Community College 503-594-0758
Data path from colleague to infoview Transforms in Datatel DORE Export and Stored Procedure ODS and SQLServer Business Objects Universe Designer InfoView Implementation Issues
What is a Transform? • Data extraction process from one Unidata file • Data fields - single and multivalued • TRANS functionality from pointers in file • Computed columns • Valcode descriptions • Basic collection of processing on data • Simple scripting functions
Transform Screens DOTA - Target Definition (A Collection of Transforms) DOTT - Transform Characteristics DOTC – Transform Column Definitions DOFC – Transform Filters, What They Do and Don’t Do DOVS – View Definition
ODS SQL Database Tables Views
Issues In Implementation • Complexity of delivered universe structures • Data not in universe – credits in student universe • Data names changed from Colleague • Null records in tables due to delivered broken filters on multivalued transforms • Transform filters that lead to unexpected results: Student AcadCred with STC.STUDENT.COURSE.SEC NE ‘’ • JRE and Browser Compatibility • Year end transactions in CF universe • Saved lists • Security