How-To

Replicating to non-DWH-datasources


Userlevel 5
Badge
  • Community Manager
  • 21 replies

With version 2.4 and above, it is easy to replicate data to DWH and to other destinations.

_Ha3JsKOh6FFjqPfXoWS3Q.png

Note: If the data source does not appear in the list, please verify your JDBC connection specifies the default schema. Add “importer.defaultSchema=<default schema>” to the JDBC connection as shown below.

Vezb5yWp3dCdLyLth8VG3Q.png

oTYaGe3F1CBTfIQOpaKF3A.png

When replicating data, simply click on the “Target data source” and select an alternate data source as a destination. This example will generate the following SQL statement to perform the update.

 

 

EXEC "UTILS.upsert"(source_table => '"demos.sah_orderdetails"', keyColumnsArray => ('salesorderid',), updateColumns => ('salesorderid',), invertUpdateColumns => TRUE, target_table => '"dwh.new_table_upsert"', surrogateKeyType => null, surrogateKeyName => null, dbmsTableCreationOptions => null, checkMaxField => null, defaultvalueIfCheckMaxFieldIsNull => null)

 

In earlier versions, this GUI functionality is not available in Data Virtuality Studio. However, we can still perform ETL operations to data sources other than DWH. Simply follow the steps below.

  1. Using Data Virtuality Studio and begin replicating a table.
    7WOB1syNbjcM-xW1auE0pQ.png
  2. Create the job with a disabled schedule. Be sure to uncheck “Enable this schedule”.
    S94kUvD09nNZ4ttllNaRvQ.png
  3. Open the “Jobs” windows and locate the job you just created.
    TiStvV8Dq8opleJQOQ9Qkg.png
  4. Right click on the job title and select “Edit”.
    plyM9ixdI1RJCdgzfE37Gw.png
  5. Change the text in the target_table parameter to the destination of your choice and click “Finish”. The text that needs to be changed is highlighted in blue.
    i-UUY3nH8VJXbFvSc67ZmA.png

0 replies

Be the first to reply!

Reply