1 / 10

UniData to SQL Conversion

UniData to SQL Conversion. Don’t lose your Informer investment…. PRESENTER: Tim Nicholson | Director of Customer Services, Entrinsik | March 6, 2012. Problem. Datatel clients are migrating from UniData to SQL Large investment in Informer reports

rusty
Download Presentation

UniData to SQL Conversion

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

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

  2. 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. Solution Write a toolthat migrates as much of the mapping and report metadata as possible.

  4. Challenges Multivalues Computed Columns / I-Descriptors

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

  6. 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. Limitations Cannot convert • TCL/ECL • Select/Returning • Remote links

  8. Informer on SQL So what’s different? • Links • Any common value • Criteria Types • Simple, compound, Where clause • No Savelist • No Normalization

  9. Informer on SQL So what’s different? • Data is normalized

  10. Thank you! Any questions?

More Related