Author: Eric Vasbinder
ERPs Applicable:
Vista
Change Data Capture (CDC) is a powerful capability, supported by Microsoft SQL, and other databases, to allow for data changes in tables to be tracked and logged, ensuring that insertions, deletions, changes, etc. will be visible and easily consumable by third party tools and applications. This allows for these tools to receive a streamlined data feed of information that they need without the need to set up heavier replication processes or to enable API access through AppXchange to every endpoint.
However, only certain tables in Vista are supported for CDC. Other tables are possible, but not supported in the application iteself.
Please click on the heading for the "Tables Supported" section below to see a LONG, detailed list of all of the tables supported for CDC.
Please create a cloud support case to request that CDC be turned on for the tables you are interested in that are in the supported list below.
The following tables and schemas are supported for CDC usage - listed in API Schema format:
{"schema":"api", "table":"vBusinessUnit"},
{"schema":"api", "table":"vGlobalEntityMap"},
{"schema":"dbo", "table":"bAPAA"},
{"schema":"dbo", "table":"bAPCO"},
{"schema":"dbo", "table":"bAPHD"},
{"schema":"dbo", "table":"bAPTD"},
{"schema":"dbo", "table":"bAPTH"},
{"schema":"dbo", "table":"bAPTL"},
{"schema":"dbo", "table":"bAPUI"},
{"schema":"dbo", "table":"bAPVM"},
{"schema":"dbo", "table":"bARCM"},
{"schema":"dbo", "table":"bARRT"},
{"schema":"dbo", "table":"bARTH"},
{"schema":"dbo", "table":"bARTL"},
{"schema":"dbo", "table":"bEMCM"},
{"schema":"dbo", "table":"bEMDM"},
{"schema":"dbo", "table":"bEMEM"},
{"schema":"dbo", "table":"bEMLM"},
{"schema":"dbo", "table":"bHQCO"},
{"schema":"dbo", "table":"bHQMT"},
{"schema":"dbo", "table":"bHQTX"},
{"schema":"dbo", "table":"bHQUM"},
{"schema":"dbo", "table":"bINLM"},
{"schema":"dbo", "table":"bINMT"},
{"schema":"dbo", "table":"bJCCD"},
{"schema":"dbo", "table":"bJCCH"},
{"schema":"dbo", "table":"bJCCI"},
{"schema":"dbo", "table":"bJCCM"},
{"schema":"dbo", "table":"bJCCO"},
{"schema":"dbo", "table":"bJCCP"},
{"schema":"dbo", "table":"bJCCT"},
{"schema":"dbo", "table":"bJCDM"},
{"schema":"dbo", "table":"bJCID"},
{"schema":"dbo", "table":"bJCIP"},
{"schema":"dbo", "table":"bJCJM"},
{"schema":"dbo", "table":"bJCJP"},
{"schema":"dbo", "table":"bJCMP"},
{"schema":"dbo", "table":"bJCOI"},
{"schema":"dbo", "table":"bJCPM"},
{"schema":"dbo", "table":"bJCPP"},
{"schema":"dbo", "table":"bPMCO"},
{"schema":"dbo", "table":"bPMCT"},
{"schema":"dbo", "table":"bPMDH"},
{"schema":"dbo", "table":"bPMDT"},
{"schema":"dbo", "table":"bPMMF"},
{"schema":"dbo", "table":"bPMOA"},
{"schema":"dbo", "table":"bPMOI"},
{"schema":"dbo", "table":"bPMOL"},
{"schema":"dbo", "table":"bPMOM"},
{"schema":"dbo", "table":"bPMOP"},
{"schema":"dbo", "table":"bPMPA"},
{"schema":"dbo", "table":"bPMPC"},
{"schema":"dbo", "table":"bPMSC"},
{"schema":"dbo", "table":"bPMSL"},
{"schema":"dbo", "table":"bPOCD"},
{"schema":"dbo", "table":"bPOHB"},
{"schema":"dbo", "table":"bPOHD"},
{"schema":"dbo", "table":"bPOIB"},
{"schema":"dbo", "table":"bPOIT"},
{"schema":"dbo", "table":"bPORD"},
{"schema":"dbo", "table":"bPREH"},
{"schema":"dbo", "table":"bSLCD"},
{"schema":"dbo", "table":"bSLHD"},
{"schema":"dbo", "table":"bSLIT"},
{"schema":"dbo", "table":"debezium_signal"},
{"schema":"dbo", "table":"vDDDS"},
{"schema":"dbo", "table":"vDDDTc"},
{"schema":"dbo", "table":"vDDSG"},
{"schema":"dbo", "table":"vDDSL"},
{"schema":"dbo", "table":"vDDSLc"},
{"schema":"dbo", "table":"vDDSU"},
{"schema":"dbo", "table":"vDDUP"},
{"schema":"dbo", "table":"vEMLocationHistory"},
{"schema":"dbo", "table":"vEMLocationHistoryAttach"},
{"schema":"dbo", "table":"vPMPOCO"},
{"schema":"dbo", "table":"vPMSubcontractCO"}
changelog
Friday, 07 February 2025 at 11:06AM:
Initial posting