FusionWare Relational Designer

View Technical Details

Speed up development of ODBC and JDBC applications

Online help and “cue card” instructions maximize productivity

Create ANSI SQL compliant views into your MultiValue data

Support Ad-hoc query and Business Intelligence tools

  FusionWare mvLynx Relational Designer
The FusionWare mvLynx Relational Designer is the essential tool for rapid development of business intelligence applications. You will require at least one copy of the Relational Designer for data mapping to aid development and maintenance of the application.

Developer Tools

Tools are included for customer mappings with SELECT UPDATE, INSERT, and DELETE methods, if required. You can associate subroutines with each view to support on-the-fly data cleansing and to allow for fixing-up data that does not conform to standard ANSI SQL data typing rules.
  Easy User Interface
The mvLynx Relational Designer offers a easy-to-follow Windows Explorer style interface for mapping the non-relational MultiValue data structures to ANSI SQL-relational views. Create mappings of your MultiValue data using drag and drop.

VB like Visual editor for creating PICK BASIC stored procedures.

Technical Information

Platform Information: 

MultiValue Platform:
• Most MultiValue databases including: uniVerse,™ UniData,™ mvBase,™ Reality X,™ jBase,™ mvEnterprise,™ D3,™ QM, Advanced Pick,™ and more. 

Applications:
Any ODBC compliant Windows application or ISAPI-compliant Web Servers, including:
• Microsoft Office (incl. Excel), Crystal Reports, Lotus®, Microsoft IIS Server, VisualBasic
• SQL Server, Andyne GQL™, Powersoft™, PowerBuilder™ and many more.

Dependancies:
• The MultiValue server must support TCP/IP sockets
• When called from a browser, the MultiValue database must be accessible by a socket connection

 

Components Include::

  • mvLynx Relational Data Access Server – required for each MultiValue host computer. Controls communication and access to the MultiValue database.
  • mvLynx Driver, ODBC Edition – ODBC Compliant Driver

Product Features:

  • Table Management
    • Define Relational Views of MultiValue files
    • Manipulate columns in the definition table (view)
    • Point-and-click mapping to place MultiValue sets of data into separate tables (views)
    • Validate defined table structures against actual file data
  • Server Management
    • Special User/Logon security model gives you fine-grained control over who can see what data
    • Add/delete users from the server
  • Administration
    • Change passwords or default databases
    • Create a database (a logical collection of tables, with user controlled security)