Update Source Feature Requirements

Update Source Feature Requirements

book

Article ID: KB0078508

calendar_today

Updated On:

Products Versions
TIBCO Scribe Insight 7.9.1

Description

Use the Update Source option on the TIBCO Scribe® Insight Workbench Configure Source dialog to update or delete source records as they are processed by a DTS or a Query Publisher.
 
kA2320000004GlkCAE_en_US_1_0

Update Source Options – DTS Source Configuration

 
kA2320000004GlkCAE_en_US_1_1
Update Source Options – Query Publisher Source Configuration
 

Using the Update Source feature in TIBCO Scribe® Insight has the following caveats:
  • Any table that is updated must have a primary key and the primary key field must also be in the First select clause.
  • The first table in the FROM portion of the query must have a primary key even if it is not being updated. Switch the order of the tables if necessary.
  • In the update source there must either be a single space or a carriage return after the word SELECT. If there is more than one space, or a tab an update source error is generated.
Note: In testing this did not seem to be true. More than 1 space or tab seemed to work fine.
  • Do not use fully qualified database.owner references , such as ScribeInternal.dbo.Tablename. You can use a table owner such as dbo.Tablename but not [dbo].[Tablename].
  • Certain characters used in the query can cause it to fail such as “Order ID”. However, something like a.fieldname works.
  • If field names have spaces you need to alias them, such as [Date Modified] As DM.
  • Other Limitations:
  • Table names cannot contain spaces. Create a synonym.
  • Sub Queries are not supported.
  • Columns created using SQL Select are not supported, such as
SELECT SUM(Amount) FROM EasternARBillingTransDetail WHERE InvoiceNumber = SOPHdr.InvoiceNumber GROUP BY InvoiceNumber) AS InvoiceTotal,

    Issue/Introduction

    Use the Update Source option on the Configure Source dialog to update or delete source records as they are processed by a TIBCO Scribe® Insight DTS or a Query Publisher.

    Additional Information

    For additional information, see the following:
    Powered by Wolken Software