SQLWord 10.0

Mailmerge Oracle - Microsoft Word

Most Oracle database users know that it is quite difficult to retrieve Oracle data into Microsoft Word documents. Sequel Solutions has developed a report generator which gives you a powerful tool to solve this problem. You can define your documents in Microsoft Word and use SQLWord to generate documents merged with the data from your Oracle database. When using SQLWord you can create your own standard letters, contracts and reports, integrating with the data of your Oracle database.

Using the SQLWord Developer application, you can place several SQL-statements enclosed by <% tag %> scriptlets inside the text of a Microsoft Word document. SQLWord follows the syntax of Oracle PL/SQL Server Pages. Microsoft Word documents with <% tag %> scriptlets can be stored by the SQLWord Developer application into your Oracle database, compiled as PL/SQL-procedures. By calling the PL/SQL-procedure SQLWord retrieves the data from your Oracle database and integrates it in the generated output document.

If you run SQLWord “web-enabled” through the Oracle HTTP server, the output document is send to the webbrowser on the client, where the document is opened with Microsoft Word (Windows) or OpenOffice (Linux).

If you run SQLWord “client-server” by using the SQLWord Runtime application, the document is created on the LAN and is opened with Microsoft Word.

SQLWord can be implemented in several "web-enabled" applications, such as Oracle Forms. An implementation example is included.

Read the SQLWord-manual

Advantages

  • Full use of all Microsoft Word options such as different lettertypes, bold, underline, graphics, tables.
  • SQL statements are defined in the source Word document.
  • Nested structures can be used unlimited (master-detail-detail etc).
  • Full use of all SQL commands such as select, insert, update, delete. IIt is also possible to define and execute PL/SQL blocks. In these PL/SQL blocks all standard PL/SQL functionality can be used, so calling stored procedures, functions and packages is no problem.
  • Conditionally use of text blocks.
  • The layout of the output document is completely done in Microsoft Word. Probably you are familiar with that !
  • Microsoft Word tables are supported and can be filled with the data retrieved from the Oracle database. This gives your documents a professional look !
  • Dynamic headers and footers are supported.
  • Graphics are supported. You can use bitmaps for logos etc.
  • During the creation of the output document it is possible to supply the parameters interactively.
  • Integration with Oracle*Forms.
  • Great performance.

Requirements

  • Oracle 9i / Oracle 10g / Oracle 11g.
  • Oracle HTTP webserver.
  • Oracle client-installation on the windows PC’s where SQLWord Developer or SQLWord Runtime is installed.

    • Prices

    License prices are based on the number of end-users. The basic license is for 1-5 users.
    For large sites we offer interesting site-licences.

    For more information about prices, please contact our sales department.

    You can download SQLWord from here.