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 27.1
Getting Started
Information and resources to help you get started using Oxygen XML Author 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
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
Additional XML Editing Frameworks (Document Types)
The custom frameworks that are supported in Oxygen XML Author
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 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.
    - JSON Transformation with XQuery
      This type of transformation specifies the transformation parameters and location of an XQuery file that is applied to the edited JSON document. This scenario is useful when you develop a JSON document and the XQuery file 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 on XML
      This type of transformation specifies the parameters and location of an XML source that the edited XQuery file is applied on.
    - XQuery Transformation on JSON
      This type of transformation specifies the parameters and location of a JSON document that the edited XQuery file is applied on. This scenario is useful when you develop an XQuery file and the JSON document is in its final form.
    - 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
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 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
Extending Oxygen With the SDK
Information about extending Oxygen XML Author using the SDK
Add-ons
Information about extending Oxygen XML Author with add-ons
Tools
Specifics about the various tools that are included in Oxygen XML Author
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
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) (Ctrl + Shift + C (Command + Shift + C on macOS)) action from the toolbar or the Document > Transformation 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.

Storage

Allows you to select one of the following storage options:

Project Options - The scenario is stored in the project file and can be shared with other users. For example, if your project is saved on a source versioning/sharing system (CVS, SVN, Source Safe, etc.) or a shared folder, your team can use the scenarios that you store in the project file.
Global Options - The scenario is saved in the global options that are stored in the user home directory and is not accessible to other users.

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. You can also use the

Open in editor button to open the specified file in the editor panel.

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.