4D 2004

CONNECTIVITY PLUG-INS

warning: file_get_contents(http://www.telize.com/geoip/54.198.221.13) [function.file-get-contents]: failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /var/www/www.4d.com/docs/includes/common.inc(1762) : eval()'d code on line 4.
Connectivity tools allow your database to grow and migrate as needs change by allowing you to connect to outside technologies.

4D Connectivity Plug-ins allow 4D developers unparalleled extensibility of their 4D applications through a variety of enterprising connectivity technologies. Each of the products listed below is available separately.

   

 

4D ODBC Pro

The 4D ODBC connectivity plug-in allows 4D to communicate with any data source accessible by an ODBC driver, enabling you to handle the data and structure of a SQL data source. 4D ODBC provides access to nearly all SQL and ODBC applications on the market. You can build anything from simple queries to transaction-based client/server applications.

 

Features

  • Access to most of the functionality of ODBC 2.0 (Core Level, Level 1 and Level 2).
  • "Pass-through" mode support.
  • Programmable manipulation of the data source data and structure files.
  • Cloning of 4D tables as ODBC tables and vice-versa.
  • Data exchange by value or by address.
  • Use of native types with automatic cross-conversion.
  • Ability to test available driver functions.
  • Support for Binary Large Objects (BLOBs).
  • Debugging wi ndow for tracing the communication between 4D and 4D ODBC.

 

Licensing notes

  • Included with 4th Dimension Developer Edition and 4D Server Developer Edition (2 connections)
  • Available for 4D Runtime Single User
  • Available for all 4D Server editions in 1-, 5- and 10-user packs

 

Migrating to 4D v11 SQL

 

NOTE: As 4D v11 SQL now integrates a complete set of high-level SQL commands and capabilities, you may evaluate the quantity of code to migrate and your low-level control needs before decinding to upgrade your 4D ODBC Pro plug-in or switch to the integrated feature.

 

NOTE: As 4D Developer Standard doesn't accept plug-ins in 4D v11 SQL, you'll lose your 4D ODBC Pro functionality if you upgrade a 4th Dimension Standard Edition license with a 4D ODBC Pro Expansion. We therefore recommend purchasing 4D Developer Professional.

 

 

 

Starting at $269

Buy now

4D for OCI

The 4D for OCI plug-in allows 4D to communicate with an Oracle Server.

 

Features

  • Direct access to the Oracle Call Interface
  • PL SQL support
  • Programmatically manipulate the data source data and structure tables
  • Cloning of 4D tables as ORACLE tables and vice-versa
  • Data exchange by value or by address
  • Implementation of deferred mode
  • Array processing
  • Support for Binary Large Objects (BLOBs)
  • Support for Character Large Objects (CLOBS)
  • Support for Oracle 8.16, Oracle 9 and Oracle 10

 

Licensing notes

  • Included with 4th Dimension Developer Edition and 4D Server Developer Edition (2 connections)
  • Available for 4D Runtime Single User
  • Available for all 4D Server editions in 1-, 5- and 10-user packs

 

Migrating to 4D v11 SQL

 

NOTE: As 4D Developer Standard doesn't accept plug-ins in 4D v11 SQL, you'll lose your 4D for OCI functionality if you upgrade a 4th Dimension Standard Edition license with a 4D for OCI Expansion. We therefore reocmmend purchasing 4D Developer Professional.

 

 

 

Starting at $59

Buy now

4D for MySQL

The 4D for MySQL plug-in provides 28 high-level commands that allow access to the data and structure of a MySQL database. The commands are implemented with the native MySQL API that bypasses a middle ODBC layer enabling all communication between 4D and MySQL to be done at the optimal speed.

 

Features

  • Direct access to any MySQL Server (one or more at a time) 
  • No pre-created ODBC data sources required 
  • PL SQL support 
  • Structure manipulation such as Create/Alter/Drop tables and fields
  • Database access and manipulation such as Select/Update/Delete records 
  • Support for MySQL 3.23.XX - 4.0.X 
  • Windows and Mac OS X support

 

Licensing notes

  • Available for 4th Dimension Developer Edition
  • Available for 4D Runtime Single User
  • Available for all 4D Server editions in 1-, 5- and 10-user packs

 

Migrating to 4D v11 SQL

  • 4D for MySQL is not maintained in 4D v11 SQL product line
  • Please consult the new integrated SQL capabilities of 4D v11 SQL to perform your connections to MySQL databases.

 

 

 

Starting at $59

Buy now

4D for PostgreSQL

The 4D for PostgreSQL plug-in provides 46 low-level commands that allow access to the data and structure of a PostgreSQL database. The commands are implemented with the native PostgreSQL API that bypasses a middle ODBC layer enabling all communication between 4D and PostgreSQL to be done at the optimal speed.

 

Features

  • Direct access to any PostgreSQL Server (one or more at a time) 
  • No pre-created ODBC data sources required 
  • PL SQL support 
  • Structure manipulation such as Create/Alter/Drop tables and fields
  • Database access and manipulation such as Select/Update/Delete records
  • Support for PostgreSQL 7.1.X to 7Windows and Mac OS X support
  •  

Licensing notes

  • Available for 4th Dimension Developer Edition
  • Available for 4D Runtime Single User
  • Available for all 4D Server editions in 1-, 5- and 10-user packs

 

Migrating to 4D v11 SQL

  • 4D for PostgreSQL is not maintained in 4D v11 SQL product line
  • Please consult the new integrated SQL capabilities of 4D v11 SQL to perform your connections to PostgreSQL servers.

 

 

 

Starting at $59

Buy now

4D for ADO

The 4D for ADO plug-in allows you to execute queries on most RDBMS’s that run on the Windows system: MS SQL Server, Oracle 8i/9i, Sybase Adaptive Server Enterprise (ESA), MS Access and many others.

 

Features

  • RDBMS access via OLE DB or ODBC
  • Database manipulation or query 
  • Connects to any ADO.Net supported back end, such as LDAP servers, etc 
  • PL SQL support
  • Windows and Mac OS X support

 

Licensing notes

  • Available for 4th Dimension Developer Edition
  • Available for 4D Runtime Single User
  • Available for all 4D Server editions in 1-, 5- and 10-user packs

 

Migrating to 4D v11 SQL

  • 4D for ADO is not maintained in 4D v11 SQL product line
  • Please consult the new integrated SQL capabilities of 4D v11 SQL to perform your connections to remote applications on Windows, or use 4D for ODBC Pro or 4D for OCI plug-ins.