• Platform Events
• Inserting Records Into a Platform Event Using SF_TableLoader

Platform Events

Platform events are event messages that applications send and receive in real-time for performing further actions. Use them to simplify the process of communicating and responding to applications. They are defined in Salesforce in the same way that you define custom objects, but platform event objects have __e appended to their API name. DBAmp supports only inserting into platform event objects. For more information on platform event objects, see https://developer.Salesforce.com/docs/atlas.en-us.platform_events.meta/platform_events/platform_events_intro.htm

NOTE: DBAmp support for platform event objects is inserting only using SF_TableLoader. DBAmp does not support any other operation, and platform events are not queryable.

Inserting Records Into a Platform Event Using SF_TableLoader

To run the SF_TableLoader stored procedure using the SOAP API to insert a record into the PETest__e platform event object, use the following command:

EXEC SF_TableLoader 'Insert', '𝘚𝘈𝘓𝘌𝘚𝘍𝘖𝘙𝘊𝘌_𝘓𝘚', '𝘗𝘌𝘛𝘦𝘴𝘵__𝘦_𝘐𝘯𝘴𝘦𝘳𝘵'

where Insert is the SF_TableLoader operation, SALESFORCE_LS is the name you gave your linked server, and PETest__e_Insert is the name of the Input table.

To run SF_TableLoader using the BulkAPI 2.0, and insert a record into PETest__e, use the following command:

EXEC SF_TableLoader 'Insert:bulkapi', 'SALESFORCE', 'PETest__e_Insert'

NOTE: The name of the platform event object ends in __e. INSERT is the only operation you can use with platform event objects for SF_BulkOps and SF_TableLoader.