Skip to main content

Uniface Development: Generate Uniface Entities from existing Sybase database

  • November 19, 2018
  • 3 replies
  • 0 views
Jan Cees Boogaard

Generate Uniface Entities from existing Sybase database

Author: disco@discooctopus.com (discooctopus)

Hi,

Has anyone got any ideas on how to generate a Uniface model from an existing Sybase database?

Back in U6, I remember being able to import a Sybase database into some third part tool (I think it was called Power Designer?), then have that tool generate a "CIF" file, and then import that into U6.  I am not sure if there is such a tool that exists now though. Any ideas?

Thanks

 

    3 replies

    Jan Cees Boogaard

    Generate Uniface Entities from existing Sybase database

    Author: disco@discooctopus.com (discooctopus)

    Hi,

    Has anyone got any ideas on how to generate a Uniface model from an existing Sybase database?

    Back in U6, I remember being able to import a Sybase database into some third part tool (I think it was called Power Designer?), then have that tool generate a "CIF" file, and then import that into U6.  I am not sure if there is such a tool that exists now though. Any ideas?

    Thanks

     

    I can only answer for the situation in Uniface 9, as 9.3 is the version I'm working with on a daily basis.

    Please search the Uniface help files for "Uniface Database Utilities" and you will find that it's stil possible for Oracle, Rdb, Informix, DB2, but unfortunately it seems not possible any more for Sybase.

    Cheers,

    Arjen


    Author: Arjen van Vliet (arjen.van.vliet@uniface.com)
    Jan Cees Boogaard

    Generate Uniface Entities from existing Sybase database

    Author: disco@discooctopus.com (discooctopus)

    Hi,

    Has anyone got any ideas on how to generate a Uniface model from an existing Sybase database?

    Back in U6, I remember being able to import a Sybase database into some third part tool (I think it was called Power Designer?), then have that tool generate a "CIF" file, and then import that into U6.  I am not sure if there is such a tool that exists now though. Any ideas?

    Thanks

     

    Hi,

    The *.CIF file has a very easy syntax.
    Just unload an entity or small model and analyse the result.

    I recommend a small executable which extracts these data and use case-load to get it inside uniface.
    Used it once to transfer a WinWord data description into uniface. Saved us some 2 weeks of typing.

     

    SUccess, Uli


    Author: ulrich-merkel (ulrichmerkel@web.de)
    Jan Cees Boogaard

    Generate Uniface Entities from existing Sybase database

    Author: disco@discooctopus.com (discooctopus)

    Hi,

    Has anyone got any ideas on how to generate a Uniface model from an existing Sybase database?

    Back in U6, I remember being able to import a Sybase database into some third part tool (I think it was called Power Designer?), then have that tool generate a "CIF" file, and then import that into U6.  I am not sure if there is such a tool that exists now though. Any ideas?

    Thanks

     

    Hi,

    You can load the definitions of your tables directly into Uniface using.... Load Definitions.
    Go To -> Administration -> Exchange Models -> Load Definitions
    It works for Sybase and some other databases

    Or you can work with CIF files:
    Go To -> Administration -> Exchange Models -> Case Load
    I don't know if there still are modelling that can export CIF files.

    Hope this helps,

    Theo Neeskens

     

     


    Author: Theo Neeskens (tneeskens@itblockz.nl)

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement