Connectivity Project

Project Overview

The Connectivity project includes components for defining, connecting to, and working with data sources.


Project Components

  • Driver Management Framework

    Access to the appropriate drivers is a prerequisite for programmatic interaction with data sources. The Driver Management Framework (DMF) supplies an Eclipse preference page enabling users to create driver definitions based on supplied templates. A number of templates are provided in the base installation, and additional templates can be added by component developers contributing to DMF extension points.

    Developers' Guide for Connectivity Frameworks (HTML)

  • Connection Management Framework

    The Connection Management Framework (CMF) is the foundation upon which specific connection types are created. The connection types, called Connection Profiles (CP), are contributed to the CMF through extension points. Users then connect to data source instances by creating and configuring a CP for that data source type. Data source-standard configuration parameters, such as the connection URL, user name, and password, are provided on CP instance creation and stored as secure meta-data for the CP. CP allow for host connectivity checks (“ping”), connection, auto-connect on CP startup, and disconnect. Further, CP Extensions enable additional functionality and content to be added to a CP. For reuse of CP instance configuration, base import/export functionality is provided by CPF and surfaced in tools such as the DSE Explorer (see below). Data source CP then become the connection providers through which other DTP tooling accesses data source instances.

    Developers' Guide for Connectivity Frameworks (HTML)

  • JDBC connection support

    DTP will include a JDBC driver template and CP, as a means of enabling database connectivity, and serving as an example for further CP development. Database-specific capabilities can then be surfaced as CP extensions, allowing for specialization and presentation of differentiating database functionality directly in that database's CP.

    Connecting to Apache Derby using DTP M2 (HTML)

  • Data Source Explorer

    The Data Source Explorer (DSE) is an Eclipse view housing CP instances. From this view, CP capabilities are surfaced, and data source content is presented. The type and level of detail for any one instance is constrained only by the CP itself. DSE also is a provider of CP instance data to clients, such as drag and drop and API calls. This allows data tooling requiring connection management to interact with the DSE as a mediator to CP instances.

    Data Source Explorer Design (HTML) (PDF)

  • Open Data Access

    The Open Data Access (ODA) component is an open and flexible data access framework that allows applications to access data from both standard and custom data sources. It enables data connectivity between data consumers and data source providers through published run-time and design-time interfaces. In addition, the framework also includes an ODA driver management package that helps an ODA consumer application to manage diverse behavior of individual ODA data drivers.

    A data driver is created simply by implementing the run-time interfaces defined by the framework. The run-time interfaces include support for establishing a connection, accessing meta-data, and executing queries to retrieve data.  A driver can define internal data source connection profiles and/or work with the CMF's Connection Profiles extensions. Once developed, the driver can be registered through an extension point with individual ODA consumer components to enable data connectivity. The framework also provides design-time interfaces to integrate custom query builders within an application designer tool. Additional ODA examples can be found in the Eclipse BIRT project.

    ODA Overview Document (HTML) (PDF)
    Developers' Guide for Connectivity Frameworks (HTML)