XML Gateway

Provides a set of tools for extracting, transforming and consolidating data from disparate sources into single or multiple destinations.
XML Gateway provides a set of tools for extracting, transforming and consolidating data from disparate sources into single or multiple destinations. Use XML Gateway tools to build modules graphically and create custom data movement solutions tailored to the specific needs. A modular approach to XML data movements using an intuitive user interface enables the creation of XML Import and Export Modules that encapsulate the logic and the rules that are required to connect to data sources and perform XML import and export operations. Once saved, the modules can be run manually, scheduled to run on a regular basis or invoked programmatically from any programming or scripting language that supports COM technology.

XML Gateway - Features

XML Gateway provides a set of tools for extracting, transforming and consolidating data from disparate sources into single or multiple destinations. Use XML Gateway tools to build modules graphically and create custom data movement solutions tailored to the specific needs. A modular approach to XML data movements using an intuitive user interface enables the creation of XML Import and Export Modules that encapsulate the logic and the rules that are required to connect to data sources and perform XML import and export operations. Once saved, the modules can be run manually, scheduled to run on a regular basis or invoked programmatically from any programming or scripting language that supports COM technology.

New Features in version 4.5 include:

• Re-usable import and export modules
• Exporting of data using a mapping screen
• Schema validation during an export operation
• Support for transactional and non-transactional export operations
• Data cleansing for after a non-transactional export operation
• Export multiple XML data structures to multiple data sources in a single operation as a distributed transaction
• Schedule data transfer
• Combine XML data structures from multiple data sources to generate a single XML structure
• Generate hierarchical XML data structures from single and multiple data sources
• Database explorer window for database management
• Access to the functionality of the XML Gateway DLL.

Features include:

• Importing Data:
  • Import XML data structures from any data source using re-usable configured modules
  • Combine XML data structures from multiple data sources to generate a single XML structure
  • Generate hierarchical XML data structures from single and multiple data sources
  • Transform XML data structure generated by a data source to any schema using a simple mapping screen
  • Compliant with SQL Server, Access, Oracle and any ODBC and OLEDB databases
  • Compliant with Web Services, HTTP and FTP protocols
  • XML Gateway provides two main choices for importing data as XML:
    • Using the Database Explorer: generate XML documents and schema from tables, views and stored procedures using a single mouse click
    • Using an Import Module: importing data as XML using an import module is the recommended option. Import modules can be configured once and re-used several times and invoked programmatically.
• Exporting Data:
  • Export any XML data structure to any database table using re-usable configured modules
  • Intuitive mapping screen using drag and drop
  • Export multiple XML data structures to multiple data sources in a single operation as a distributed transaction if required
  • Table creation Wizard during the export module configuration
  • Support for insert, update and delete operations during an export operation
  • Support transactional and non-transactional export operations
  • Support for data cleansing after a failed export operation. Failed records can be re-submitted after the cleansing operation
  • Compliant with SQL Server, Access, Oracle and any ODBC and OLEDB databases
  • Compliant with Web Services, HTTP and FTP protocols
  • Export any XML data structure to any table in any database that supports ODBC or OLEDB. XML Gateway provides three main choices for exporting data:
    • Using the Export Wizard: copy data between OLE DB data sources using the Wizard as a guide through the process of connecting to a destination, selecting the table destination, setting the transaction attributes and applying mappings to the data being copied
    • Using Drag and Drop: transfer data using drag and drop, by creating a Data Link to the destination and source data sources and dragging a table, view or store procedure from the source database and dropping it onto a table in the destination database
    • Using an Export Module: exporting data using an export module is the recommended option. Export modules can be configured once and re-used several times. An export module can be invoked programmatically.
• Scheduling:
  • Schedule a saved Export Module to execute at specific times, either once or at recurring intervals. A scheduled Export Module is executed by the XML Gateway Agent as a job. If the export module is non-transactional, XML Gateway creates a data cleansing file every time that a job runs for records that have failed
  • The following functions can be performed on a job module using a context menu:
    • Start: starts the XML Gateway Agent and schedules the job execution
    • Stop: stops the XML Gateway Agent for the specific module and halts the execution of the job
    • Delete: deletes the current job
    • View Log: views the job for the current log
    • Clear Log: clears the log for the current job
    • Refresh Log: refresh the log for the current job
    • Job Properties: view the job configuration screen for the editing.
• Data Cleansing:
  • Configure a transaction attribute during an export operation:
    • Transaction Required: the default. XML Gateway uses a transaction to perform the export process. The entire export transaction is rolled back if an error occurs during the process
    • Transaction Disabled: XML Gateway commits all successful records and displays all failed records in a screen enabling the user to cleanse the data and re-submit it.
• Database Management: use the XML Gateway Database Explorer to view and manipulate data links and database connections. The Database Explorer window presents a view onto one or more database connections, providing access to the entire structure of the database on a particular connection to enable visual manipulation of the structure of a database. Live editable data is displayed from databases to which a data connection has been made. Once a connection has been established it is possible to use the Database Explorer to perform the following functions:
  • View and edit data from tables, views or stored procedures
  • Delete data from a table using a query builder
  • Generate XML data and Schemas from tables, views and stored procedures
  • Create and delete tables, views and stored procedures
  • Use a query a builder to build SQL queries and use them to return and manipulate data
  • Export data to Microsoft Excel and Word, Text Files, HTML and any OLEDB or ODBC data source using the Export Wizard
  • Drag and drop to export data from one data link to another using the Export Wizard.
• XML Editor: provides functionality for manipulating XML documents:
  • Create and modify XML documents
  • View XML in different ways
  • Modify XML data using a grid view
  • Generate XML Schemas
  • Validate XML documents against Schemas
  • Export data to Microsoft Excel spreadsheets, Text files and Word documents, HTML files and any database and access the export options by right-clicking on an XML document
  • Support for insert, update and delete operations during an export operation
  • Support for transactional and non-transactional export operations.
• Query Designer: a tool for creating SQL commands using an intuitive visual interface. Create complex, multi-table queries by adding tables into queries, selecting options and entering values.
  • Work visually or with SQL commands using graphical panes that display the query visually and an SQL pane that displays the SQL text of the query
  • Create database-aware commands
  • Join related tables enabling the Query Designer to determine how the tables are related and to construct the appropriate join command in the query
  • Execute a query and work with a recordset in a grid that enables scrolling through and editing of records in the database.
• XML Gateway DLL: a comprehensive set of XML interfaces for building high-performance XML-based applications that enable inter-operability with other applications that adhere to the XML 1.0 standard.
  • Connect to any data source via OLEDB and ODBC and generate XML data and XML Schemas via standard SQL, Shape command or stored procedures
  • Connect to an FTP or HTTP site and retrieve XML data files
  • Validate an XML document against DTDs and the current standard W3C XML schemas
  • Transform an XML document to any other well formed mark up including XML to XML and XML to XHTML transformations
  • Export XML via OLEDB, ODBC, FTP and HTTP.
    • Main Classes:
      • Database Link: exposes the main interfaces for connecting to a data source (OLEDB, ODBC, Excel, Text Files) and generates XML using standard SQL commands, Shape commands, tables and running stored procedures with or without parameters
      • Database Export: exposes the main interfaces for exporting XML data to a database table. XML data can be exported any database that is OLEDB or ODBC compliant and to Microsoft Excel spreadsheets, Word documents and Text Files
      • Web Link: exposes the main interfaces for sending and retrieving XML documents via FTP, HTTP and from the SQL Server 2000 XML interface
      • Validation: exposes the main interfaces for validating XML documents against DTDs and the current W3C XML Schemas
      • Transformation: exposes the main interfaces for transforming XML documents to another XML document or HTML.
    
    

    XML Gateway - System Requirements

    • Microsoft Windows NT 4.0 (Intel) operating system, 2000, 98 or 95 with the latest Service Pack installed
    • Pentium-class PC (300 MHz or higher recommended)
    • 64 MB of RAM (128 MB recommended)
    • Super VGA monitor with the following settings:
      • Screen resolution set to a minimum of 800 x 600 and up to a maximum of 1024 x 768
      • Small fonts selected.
    • Microsoft Internet Explorer 5.0 or higher
    • Client/Server technologies such as RDBMS, FTP, MSMQ, HTTP, e-mail etc. (Must be correctly configured with appropriate security permissions and licensing).