Test Data Manager

Expand all | Collapse all

Javelin - Oracle source table to target table without Bulkupload

Jump to Best Answer
  • 1.  Javelin - Oracle source table to target table without Bulkupload

    Posted 11-07-2019 11:11 AM
    Hi All,
    Is there any way in Javelin, we could insert data from source table to target table for Oracle with out using BulkImport utility.

    Thanks
    Rajesh


  • 2.  RE: Javelin - Oracle source table to target table without Bulkupload
    Best Answer

    Posted 11-13-2019 01:50 AM
    Hi Rajesh,

    You could try the following: Use only one BulkCopy element with variables. If you put this in a ForEach element with a schema definition table you can manage the whole copy proces from within that table. I gave this table the follwing attributes:
    [systeem]
    ,[schema]
    ,[db]
    ,[tablename]
    ,[type] ((C)onfiguration,(T)ransaction,(L)og,(R)eference)
    ,[subset] (Y/N)
    ,[comment]
    ,[connection] (the attribute with which to subset, f.i. the userid)
    ,[selection] (if it's different from a 'select *')
    ,[condition] (should you use a where clause)
    ,[relatie] (optional parent table)
    ,[relatie_id] (the linking attribute in the parent table)
    ,[sequence] (the hiërarchy)
    So a query element returns these values and for each of these lines the values are transferred to variables with which the BulkCopy is run. 
    "select * from "+varTabelnaam+" where "+varConditie+" and "+varConnectie+" in ( select nummer COLLATE Latin1_General_CI_AS from scramble.dbo.subset_selectie where systeem = '"+varSysteem+"' )"

    No need to use GTSubset anymore and a Javelin workflow with just one bulkcopy element. For child records 

    Best regards,
    Klaas-Jan Lute