0

Source DB Table Change, New Fields Added

Can someone provide an update on what happens when a new field is introduced to a table in the Source DB -- and is being synchronized to Incorta?

Will Incorta automatically identify the additional field and add it to the existing schema during the next synchronization?

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Incorta will not by default synchronize with the DDL changes in the source system.  It's easy to address, as often this is simply a small change to the SQL statement (select col1, newcol from source_table) that is defined in Incorta .

    Reply Like 1
  • It is also worth noting that Incorta, by default, lists out each field name in the SELECT statements that define each Incorta table.  This is by design.  By listing each field name, rather than performing a SELECT * FROM <table>, Incorta is less vulnerable to failure when a new column is added to the source system table.  To Seth Luersen 's point, it still doesn't sync automatically, but this give us a more robust way to elude failure when the source system changes.

    Reply Like 1
Like Follow
  • 2 mths agoLast active
  • 2Replies
  • 22Views
  • 3 Following