Uploaded image for project: 'JOC - JobScheduler Operations Center'
  1. JOC - JobScheduler Operations Center
  2. JOC-1305

Add functionality to export results in CSV, XML, JSON from by JITL Database Job Templates

    XMLWordPrintable

Details

    • Feature
    • Status: Released (View Workflow)
    • Minor
    • Resolution: Fixed
    • 2.0.0
    • 2.4.0
    • None
    • None

    Description

      Current Situation

      • The SQLExecutorJob Template offers to export the result set of a database query to a file in CSV format.

      Desired Behavior

      • Export formats for database queries should include
        • XML
        • JSON
      • The following JITL Job Templates should support the same functionality to export to CSV, XML and JSON files:
        • PLSQLJob

      Maintainer Note

      • com.sos.jitl.jobs.db.SQLExecutorJob
        • resultset_as_variables accepts additionally XML and JSON values (case insensitive).
      • com.sos.jitl.jobs.db.oracle.PLSQLJob
        • 2 new arguments introduced:
          • resultset_as
            • Default - empty. Possible values: CSV, XML or JSON (case insensitive).
          • result_file
            • The path to the output file that holds the result set in csv/xml/json format.

      Attachments

        Activity

          People

            re Robert Ehrlich
            ap Andreas Püschel
            Pratishtha Pandey Pratishtha Pandey
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: