U2 DBTools
U2 DBTools
Database tools for developers and administrators U2 DBTools include the Eclipse-based tools for programming and administration. Discover the latest tools that work with both U2 databases: Basic Developer Toolkit (BDT), XAdmin (Extensible Administration Tool), U2 Web Services Developer (U2WSD), and more.
Basic Developer Toolkit (BDT)
This tool provides a modern integrated development environment (IDE), and consists of a set of Eclipse plug-ins for working with U2 Basic programs. BDT’s code editor helps developers to write code more efficiently while achieving better readability and maintainability, and provides advanced features such as in-line syntax checking, code completion, hover help, refactoring, code style templates, compiling and cataloguing programs, editing dynamic arrays and HTML, as well as many other capabilities useful to experienced and new programmers alike. BDT’s debugger allows stepping line-by-line into and over a subroutine, setting breakpoints, watching variables, and attaching to a background program.
Extensible Administration Tool (XAdmin)
XAdmin is a tool that includes key administration functions for UniData and UniVerse. Its major features include performance monitors with configurable report views, alerts, a record and replay facility, SSL and data encryption administration, replication administration and monitoring, a licensing wizard, client/server logging, and other features. XAdmin simplifies administration tasks with a modern user interface that provides resizable, movable, detached views; filters for server/account/file views or columns of output views; a table/tree user interface for the configuration editor; and bubble help. Users can extend XAdmin by adding their own administration menus to call BASIC routines or adding tasks to the Admin Task view. They can also embed XAdmin views into their own Eclipse-based applications.
EDA Schema Manager
External Database Access (EDA) Schema Manager is a tool for mapping UniData or UniVerse dictionaries to relational database schemas, and for converting data stored in a UniData or UniVerse database to relational databases such as Microsoft SQL Server or Oracle. After mapping the data with EDA Schema Manager, information can be transparently accessed and updated using existing BASIC programs, a U2 query, or U2 SQL.
U2 RESTful Web Services Developer
U2 RESTful Web Services Developer is a tool designed to define and publish U2 resources, such as data files and subroutines, to a U2 REST server so they can be accessed in a RESTful manner. It enables simple, lightweight, HTTP-based access to these resources, which is ideal for the development of browser-based and smart phone-based Web 2.0 applications. U2 RESTful Web Services can be consumed on any platform and in any programming language, including BASIC, PHP, Python, or other dynamic languages. Support is provided for SSL secure communications, HTTP-based user authentication, optimistic concurrency control, and connection pooling. U2 REST uses JavaScript Object Notation (JSON), a lightweight data interchange format supported by all internet browsers, to transmit data between the client service and the U2 RESTful Web service in a quick and efficient manner.
SSL Configuration Editor
UniData and UniVerse support the ability of client applications to make secure connections to the database server through Secure Sockets Layer (SSL). The SSL Configuration Editor is a graphical user interface (GUI) tool for configuring and managing the Secure Socket Layer setup and defining the characteristics of the secure connection.
U2 Web Services Developer (WSD)
U2 Web Services Developer provides a simple and easy environment for users to publish UniData or UniVerse database resources (such as subroutines or queries) as Web services, without requiring an extensive knowledge of XML, SOAP, WSDL or any other Web services technologies. U2 Web Services Developer provides built-in tools for testing published web services and for configuring and monitoring the U2 Web Services Server, and support is provided for SSL secure communications and connection pooling.
XML/DB Mapping Tool
This tool provides a drag-and-drop interface for mapping UniData and UniVerse dictionaries to XML Schema, importing data from XML, and exporting U2 data to XML.
