1 / 19

How Open is OpenInsight?

How Open is OpenInsight?. Connecting our Database to Other Technologies. Introduction. Extending OpenInsight Connecting to Other Databases Using OpenInsight from Other Applications. Extending OpenInsight. DLLs COM Objects OLE/ActiveX Controls .NET. DLLs.

hidi
Download Presentation

How Open is OpenInsight?

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. How Open is OpenInsight? Connecting our Database to Other Technologies

  2. Introduction • Extending OpenInsight • Connecting to Other Databases • Using OpenInsight from Other Applications

  3. Extending OpenInsight • DLLs • COM Objects • OLE/ActiveX Controls • .NET

  4. DLLs • Access third party utilities and libraries • Utilize the Win32 API • Improve Performance • Write performance critical modules in C++ • DLL Hell • Examples: • SRP Mail, SRP Array, SRP Buffer

  5. COM Objects • Access third party utilities and libraries • Commercial • Propriety • OLE Automation Objects • Microsoft Office • Demo: Automating MS Word • COM Objects must be registered • Increases deployment difficulty

  6. OLE/ActiveX Controls • Extends the User Interface • Advanced versions existing controls • Provide unique data visualization • Demos • Scheduling Interface • SRP OLE Controls • Not all third party controls are compatible • Must be Registered

  7. .NET • Splaver’s OIdotNET • .NET Controls use ActiveX technology • .NET Components use COM Object support • Demo

  8. Connecting to Other Databases • ODBC • Universe/Unidata Bond • XML • CTO / AREV32

  9. ODBC • Connect to existing databases • Database provides ODBC compliant driver • Read and Write Support • Ideal for: • Migrations • Inter-Database Communication • Example • BOBWare

  10. Universe/Unidata Bond • Treats Universe tables like OpenInsight tables • Uses COM support • OpenInsight 7.1 or greater • Useful for • Migrations • Modernizing Graphical Use Interface

  11. XML • Simple • Database Independent • Standards Bases • Ready for Web • Soap • XML is Multi-valued • Delimiters = Tags

  12. CTO / AREV32 • CTO • Embedded Green Screens • AREV32 • Based on CTO • Executes AREV applications within OI windows • Excellent for Migrations • Tables Imported into OpenInsight

  13. Using OpenInsight from Other Applications • OpenInsight ODBC Driver • RevCAPI / RevShell DLLs • XRev COM Object • EngineServer / OECGI

  14. OpenInsight ODBC Driver • Read Only • Export Data into ODBC Client Applications • MS Excel • MS Access • Useful for sending OpenInsight data to client databases

  15. RevCAPI / RevShell DLLs • Supported by Most Languages • Low Level • Manual Memory Management • More Complicated

  16. XRev COM Object • More Object Oriented • Supported by Higher Level Languages • Visual Basic • .NET • Useful for Integrating Modern GUIs • .NET Forms • ASP.NET • Demo

  17. EngineServer / OECGI • Manage Remote Engines • OECGI / OECGI2 • Internet • EngineServer • Great for Servers • Emulate Threading

  18. Conclusion • Extending OpenInsight • Enhance GUI • Added Functionality • Connecting to Other Databases • Simpler Migration • Communication • Using OpenInsight from Other Applications • Export to Other Applications • Provide Alternative GUI

  19. Thank You Any Questions?

More Related