Assure DQ

Welcome to the Assure DQ community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  Can Assure 9.1 write to Oracle database outside of the Assure tool databases?

    Posted 10-08-2019 09:18




  • 2.  RE: Can Assure 9.1 write to Oracle database outside of the Assure tool databases?

    Posted 10-16-2019 07:53

    Hi Ellen,

    Assure isn't designed to output data to an external source since that capability was incorporated into Perceive and DQ+ instead.

    Thank you,

    Brenda Stoetzer, Support Relationship Manager



  • 3.  RE: Can Assure 9.1 write to Oracle database outside of the Assure tool databases?

    Employee
    Posted 10-19-2019 09:08

    Ellen,

    Multi-capture and scan control points can have an export data rule: see More > Manage Export Data. This feature can export to any relational database (JDBC compatible) target table accessible from the server. The system performs simple table inserts in batches to this target. In other words, we don't do anything sophisticated or high-performance in this process, as opposed to the Perceive or DQ+ transfer mechanisms.

    Release 9.1 and above of Assure have an export control data utility that produces bulk-load-friendly delimited files. This particular utility feature is distinctly licensed - you can see its status on Help > About Us as "Export Server Utility Module".

    The upcoming 9.3 release is extending the export control data utility with additional selection command line options around cycles and runs. It is also extending the control point export data rule to be able to produce a similar delimited data file instead of targeting a relational database.