... |
To see a full list of available translators, see [Translators#Reference Guide] |
If there's not an available translator that meets your need, Teiid provides the framework for developing your own custom translator. See the [Translator Development] section, as it will describe how to develop, package and deploy a custom developed translator. |
|
h3. Custom Translators Below are the high\-level steps for creating custom Translators, which are found in the [Translator Development] section. This section covers how to do each of these steps in detail. It also provides additional information for advanced topics, such as streaming large objects. |
|
For sample Translator code, refer to the Teiid source code at [https://github.com/teiid/teiid/tree/master/connectors/]. # Create a new or reuse an existing Resource Adapter for the EIS system, to be used with this Translator. Refer to [Custom Resource Adapters|#Custom Resource Adapters]. # Implement the required classes defined by the Translator API. # Create an ExecutionFactory – Extend the {{org.teiid.translator.ExecutionFactory}} class # Create relevant Executions \(and sub\-interfaces) – specifies how to execute each type of command Refer to [Translator Development]. # Define the template for exposing configuration properties. Refer to [Packaging]. # Deploy your Translator. Refer to [Deployment]. # Deploy a Virtual Database \(VDB) that uses your Translator. # Execute queries via Teiid. |
h1. Do You Need a New Resource Adapter? |
... |
To see a full list, see [Deploying VDB Dependencies#Administrator's Guide] |
h3. Custom Resource Adapters |
If there's not an available resource-adapter that meets your need, Teiid provides the framework for developing your own JEE JCA Connector. See the [Developing JEE Connectors] section, as it will describe how to develop, package and deploy a resource adapter. |
|
Below are the high\-level steps for creating a Resource Adapter, which are found in the [Developing JEE Connectors] section. This section covers how to do each of these steps in detail. It also provides additional information for advanced topics, such as transactions. |
|
For sample resource adapter code refer to the Teiid Source code at [https://github.com/teiid/teiid/tree/master/connectors/]. # Understand the JEE Connector specification to have basic idea about what JCA connectors are how they are developed and packaged. Refer to [http://java.sun.com/j2ee/connector/]. # Gather all necessary information about your Enterprise Information System \(EIS). You will need to know: #* API for accessing the system #* Configuration and connection information for the system #* Expectation for incoming queries/metadata #* The processing constructs, or capabilities, supported by information system. #* Required properties for the connection, such as URL, user name, etc. # Base classes for all of the required supporting JCA SPI classes are provided by the Teiid API. The JCA CCI support is not provided from Teiid, since Teiid uses the Translator API as it's common client interface. You will want to extend: #* BasicConnectionFactory – Defines the Connection Factory #* BasicConnection – represents a connection to the source. #* BasicResourceAdapter – Specifies the resource adapter class # Package your resource adapter. Refer to [Build and Package the Adapter]. # Deploy your resource adapter. Refer to [Build and Package the Adapter]. |
h1. Other Teiid Development |
... |
This guide contains information for developers creating custom solutions with Teiid. It covers creating JEE JCA connectors with the Teiid framework, Teiid Translators, Teiid User Defined Functions (UDFs) as well as related topics.
Integrating data from a Enterprise Information System (EIS) into Teiid, is separated into two parts.
A Translator is used to:
A Resource Adapter is used to:
Teiid provides several translators for common enterprise information system types. If you can use one of these enterprise information systems, you do not need to develop a custom one.
Teiid offers numerous built-in translators, including:
Works with many relational databases. The JDBC translator is validated against the following database systems: Oracle, Microsoft SQL Server, IBM DB2, MySQL, Postgres, Derby, Sybase, H2, and HSQL. In addition, the JDBC Translator can often be used with other 3rd-party drivers and provides a wide range of extensibility options to specialize behavior against those drivers.
Provides a procedural way to access the file system to handle text files.
Provides procedural access to XML content using Web Services.
Accesses to LDAP directory services.
Works with Salesforce interfaces.
To see a full list of available translators, see Translators#Reference Guide
If there's not an available translator that meets your need, Teiid provides the framework for developing your own custom translator. See the Translator Development section, as it will describe how to develop, package and deploy a custom developed translator.
As mentioned above, for every Translator that needs to gather data from external source systems, it requires a resource adapter.
The following are some of resource adapters that are available to Teiid:
To see a full list, see Deploying VDB Dependencies#Administrator's Guide
If there's not an available resource-adapter that meets your need, Teiid provides the framework for developing your own JEE JCA Connector. See the Developing JEE Connectors section, as it will describe how to develop, package and deploy a resource adapter.
Teiid is highly extensible in other ways: