Choosing the Right Database
More OpenBase SQL Products
What's new in OBSQL 10.0
Openbase SQL Documentation



Server Platforms Supported include:


Client Platforms Supported include:


Server Requirements:



Interfaces

Espresso C++ and Objective-C APIs
Offers an object interface to database data.

JDBC3.0 Level 4 Driver
Provides full access from any Java application running on any platform that supports Java.

4D Plugin
Facilitates the development of 4th Dimension applications that communicate with OpenBase databases.

ActualODBC Driver
Offers ODBC connectivity for applications supporting the ODBC standard.

OpenBase Forms
Speeds building event driven database applications using an easy-to-use interface.

REALbasic Plugin
Provides compatibility with the REALbasic, a powerful programming environment for PC and Mac platforms.

PHP4 and PHP5 Plugin
Uses compiled modules and source to provide easy PHP access from Mac and Linux platforms.

Perl Compatibility
Provides full compatibility with Perl using the JDBC DBI.

Omnis Studio DAM
Provides full compatibility with Omnis Studio for building cross-platform database applications.

WebObjects Compatibility
Provides seamless integration with WebObjects development tools.

Cold Fusion Compatibility
Provides seamless integration with Cold Fusion through JDBC.



Tools

Database Management Tools

The new OpenBase Manager offers a slick MacOS X look-and-feel in addition to powerful new database management capabilities, including:

  • In-line database status progress bars
  • Drag-and-drop database groups
  • Detachable database monitoring windows
  • Color-coded databases
  • Expanded views of database descriptions and sizes
  • Log files showing error severity and alarms
  • New action buttons and contextual menus giving easy access to all database functions
  • Integrated OpenBase Forms and OpenBase Forms Wizard

OpenBase Manager is also available on Windows and Linux, but with a less-rich feature set.

Interactive SQL Program (openisql)
Provides the ability to run automated SQL scripts, execute ad-hoc SQL queries and perform data import and export functions.

OpenBase Monitor
Offers database activity graphing and monitoring.

Schema Migrator
Provides easy migration of your database schema from an offline developer copy of your database to your production database.

OpenBase Form Wizard
Allows you to take any set of related tables and turn it into a form that can be edited from OpenBase Forms or any application that embeds the OpenBase Forms framework.

OpenBase Form Designer
Makes it easy to develop full-featured business applications based on OpenBase Forms. Comes with a GUI editor for repositioning wigets, specifying business logic and creating new forms.


Data Migration Tools

Tabular Data Import
Allows you to import and map tabular or comma-separated data into multiple joining database tables, using a simple drag-and-drop interface.

FileMaker Conversion [Requires FileMaker-2-OpenBase (sold separately)]
Converts existing FileMaker Pro databases into the OpenBase SQL format in just one easy step.

MySQL Conversion
Upgrades hard-to-manage MySQL or FrontBase databases quickly and easily to OpenBase SQL. SQL-2-OpenBase converts tables, columns and data. Datatypes are automatically mapped and can be easily customized.


Open Source Tools

OpenBaseAPI
Provides the complete OpenBase C API source, with a sample Project Builder project. This code is portable to other platforms, including Windows and Linux.

openisql_ascii
Allows command-line SQL access to OpenBase SQL and many of its features.

OpenBase Forms Client
Allows users to embed? OpenBase Forms inside their applications. Open Forms Client source is available [provided?] when you purchase the OpenBase Form Designer (sold separately).


SQL Features


Select

Sub-select

Create Table

Create Index

Create Unique Index

Create Clustered Index

Alter Table

Insert

Update

Delete

Inner and Outer joins

Derived Columns

Aggregate Functions

String Functions

Views

Between

In

Exists

Like

Sounds Like

Group By

Order By

Drop Index

Drop Table

Development Support includes:


OpenBase Forms Wizard JDBC 2.0

Driver 4D Plugin REALbasic Plugin

ODBC Driver (third party) Omnis

Studio DAM Espresso Cocoa API

Framework C-API libraries and
source Interactive command line

SQL utility Example programs

Documentation


OpenBase Manager features:

  • Starting databases remotely
  • Database creation and maintenance
  • User administration
  • User access control
  • Scheduling online backups
  • Configuring replication
  • Schema reporting
  • Realtime database load monitoring
  • Full data import, export and backup functions

© Copyright 2008 OpenBase International, Ltd. All rights reserved.