This article describes how to upload a set of business data needed for a reproduction scenario to a support ticket.

Instructions

Despite our efforts to ensure your business data is not compromised: you must always make sure to anonymize the data uploaded using the SQL anonymize function, random number generators, MD5 checksum or other approaches.

Export

Execute the following steps within Invantive Query Tool or chosen Invantive product:

  • Run the query which contains the data, such as:

select /*+ ods(false) */ 
       t.* 
       except description
       ,      amtdebit
       ,      amtcredit
--
-- Anonymize text using MD5 or anonymize.
--       
,      md5(description) description
--
-- Replace sensitive amounts by a random number.
--
,      random(100) * 2500 - 1250 amtdebit
,      random(100) * 2500 - 1250 amtcredit
from   profit_transactions@afasonline t
where  t.year   = 2019 
and    t.period = 1 
--
-- Limit data set to what is needed to reproduce the issue on hand.
--
limit  1000
SQL
  • Then export the results to a file using:

local memorize results clipboard data

local save results clipboard data to "c:\temp\data.json" format json
CODE
  • Add the resulting file to the ticket.

Import

The support team will use steps such as the following to import your data into a session:

  • Load data into an in-memory table:

local load results clipboard data from "c:\temp\data.json" format json

local insert results clipboard data in table testdata@inmemorystorage create
CODE
  • The data is now ready for use.

  • For high volume test cases, an additional step is executed such as:

create or replace table largetestdata@inmemorystorage
as
select /*+ ods(false) */ *
from   testdata@inmemorystorage
join   range(750, 0)@datadictionary
SQL