UniData to SQL Conversion: Don't lose your Informer investment

1. 2012 Entrinsik, Inc. UniData to SQL Conversion Dont lose your Informer investment PRESENTER: Tim Nicholson | Director of Customer Services, Entrinsik | March 6, 2012

2. 2012 Entrinsik, Inc. Problem Datatel clients are migrating from UniData to SQL Large investment in Informer reports Unidata is to SQL what oil is to water Different structure Different query language

3. 2012 Entrinsik, Inc. Solution Write a tool that migrates as much of the mapping and report metadata as possible.

4. 2012 Entrinsik, Inc. Challenges Multivalues Computed Columns / I-Descriptors

5. 2012 Entrinsik, Inc. Multivalues PERSON UniData @ID FIRST.NAME LAST.NAME PERSON SQL PERSON_ID FIRST_NAME LAST_NAME PERSON_LS PERSON_ID POS WHERE_USED PEOPLE_EMAIL PERSON_ID POS PERSON_EMAIL_ADDRESSES PERSON_EMAIL_TYPES WHERE.USED PERSON.EMAIL.ADDRESSES PERSON.EMAIL.TYPES

6. 2012 Entrinsik, Inc. Computed Columns/I-Descriptors Become T-SQL functions Not associated with a table Take primary key as parameter Once mapped, treat like any other property Available in 4.3 Can use in SQL Block (4.2.8) as well

7. 2012 Entrinsik, Inc. Limitations Cannot convert TCL/ECL Select/Returning Remote links

8. 2012 Entrinsik, Inc. Informer on SQL So whats different? Links Any common value Criteria Types Simple, compound, Where clause No Savelist No Normalization

9. 2012 Entrinsik, Inc. Informer on SQL So whats different? Data is normalized

10. 2012 Entrinsik, Inc. Thank you! Any questions?