Home
Publishing
Details about transformation scenarios and customizing various types of output
Transformation Scenarios
Creating New Transformation Scenarios
SQL Transformation
This type of transformation specifies a database connection for the database server that runs the SQL file associated with the scenario. The data processed by the SQL script is located in the database.

Introduction
Welcome to the User Manual of Oxygen XML Author Eclipse plugin 26.1
Getting Started
Information and resources to help you get started using Oxygen XML Author Eclipse plugin as quickly as possible
Installation
The requirements and installation instructions for each platform
Configuration
Description of all of the options that allow you to configure Oxygen XML Author Eclipse plugin
Perspectives
The Editor and Database perspectives
Editing Modes
The Text, Grid, and Author editing modes
Working With Documents
General information about features available when working with documents
Editing Supported Document Types
Details about the various types of supported documents and their unique editing features
Built-in Frameworks (Document Types)
The editing frameworks that are supported in Oxygen XML Author Eclipse plugin
Additional XML Editing Frameworks (Document Types)
The custom frameworks that are supported in Oxygen XML Author Eclipse plugin
Publishing
Details about transformation scenarios and customizing various types of output
- Transformation Scenarios
  - Built-in Transformation Scenarios
  - Creating New Transformation Scenarios
    - XML Transformation with XSLT
      This type of transformation specifies the transformation parameters and location of an XSLT stylesheet that is applied to the edited XML document. This scenario is useful when you develop an XML document and the XSLT document is in its final form.
    - XML Transformation with XQuery
      This type of transformation specifies the transform parameters and location of an XQuery file that is applied to the edited XML document.
    - XML to PDF Transformation with CSS
      This type of transformation uses the Oxygen PDF Chemistry processing engine to obtain PDF output by applying CSS styling to the edited XML document. This scenario is useful for those who are familiar with CSS and want to obtain PDF output as its final form.
    - DITA-OT Transformation
      This type of transformation specifies the parameters for an Ant transformation that executes a DITA-OT build script. Oxygen XML Author Eclipse plugin includes a built-in version of Ant and a built-in version of DITA-OT, but other versions can be set in the scenario.
    - Ant Transformation
      This type of transformation allows you to configure the options and parameters of an Ant build script.
    - JSON Transformation with XSLT
      This type of transformation specifies the transformation parameters and location of an XSLT stylesheet that is applied to the edited JSON document. This scenario is useful when you develop a JSON document and the XSLT document is in its final form.
    - XSLT Transformation on XML
      This type of transformation specifies the parameters and location of an XML document that the edited XSLT stylesheet is applied on. This scenario is useful when you develop an XSLT document and the XML document is in its final form.
    - XSLT Transformation on JSON
      This type of transformation specifies the parameters and location of a JSON document that the edited XSLT stylesheet is applied on. This scenario is useful when you develop an XSLT document and the JSON document is in its final form.
    - XProc Transformation
      This type of transformation specifies the parameters and location of an XProc script.
    - XQuery Transformation
      This type of transformation specifies the parameters and location of an XML source that the edited XQuery file is applied on.
    - SQL Transformation
      This type of transformation specifies a database connection for the database server that runs the SQL file associated with the scenario. The data processed by the SQL script is located in the database.
  - Editing a Transformation Scenario
  - Duplicating a Transformation Scenario
  - Applying Associated Transformation Scenarios
  - Configure Transformation Scenario(s) Dialog Box
  - Batch Transformations
  - Sharing Transformation Scenarios
  - Transformation Scenarios View
- WebHelp Output Customization
- DITA to PDF Output Customization
- DocBook to PDF Output Customization
Working with XPath Expressions
Information about using XPath Expressions in Oxygen XML Author Eclipse plugin
Working with Archives
Describes how to use the Archive Browser to work with various type of archives
Databases and SharePoint
Connecting to supported databases and integrating Oxygen XML Author Eclipse plugin with SharePoint
Importing Data
Information about how to import data from external sources into XML documents
Framework and Author Mode Customization
Tutorials and details about customizing frameworks and the visual Author editing mode
Extension Points for the Oxygen Eclipse Plugin
A list of extension points available for the Oxygen Eclipse plugin
Tools
Specifics about the various tools that are included in Oxygen XML Author Eclipse plugin
Troubleshooting
A compilation of common problems and their solutions
DITA Authoring
A guide to help content authors who create and publish DITA content
Scripting Oxygen
Details about the scripting possibilities that are available with Oxygen XML Author Eclipse plugin
Glossary
Copyright
Legal information

SQL Transformation

This type of transformation specifies a database connection for the database server that runs the SQL file associated with the scenario. The data processed by the SQL script is located in the database.

To create an SQL transformation scenario, use one of the following methods:

Use the Configure Transformation Scenario(s) (Alt + Shift + T, C (Command + Option + T, C on macOS)) action from the toolbar or the XML menu. Then click the New button and select SQL transformation.
Go to Window > Show View and select Transformation Scenarios to display this view. Click the New Scenario drop-down menu button and select SQL transformation.

Both methods open the New Scenario dialog box. This dialog box allows you to configure the following options that control the transformation:

Name: The unique name of the SQL transformation scenario.
SQL URL: Allows you to specify the URL of the SQL script. You can specify the path by using the text field, its history drop-down, the Insert Editor Variables button, or the browsing actions in the Browse drop-down list.
Connection: Allows you to select a connection from a drop-down list. To configure a connection, use the Advanced options button to open the Data Source preferences page.
Parameters: Allows you to add or configure parameters for the transformation.