Create a Microsoft Dataverse Writer application
Create a Microsoft Dataverse Writer application using TQL
The following TQL creates a Striim app that writes to Microsoft Dataverse.
CREATE OR REPLACE APPLICATION MySQLTODv USE EXCEPTIONSTORE TTL : '7d' ; CREATE FLOW MySQLTODv_SourceFlow; CREATE SOURCE MySQLTODv_MysqlCDC USING Global.MysqlReader ( Compression: false, Password_encrypted: 'true', Tables: '"waction"."test"', connectionRetryPolicy: 'retryInterval=30, maxRetries=3', FilterTransactionBoundaries: true, Password: '<password>', ConnectionURL: 'jdbc:mysql://127.0.0.1:3306', SendBeforeImage: true, Username: 'root' ) OUTPUT TO MySQLTODv_OutputStream; END FLOW MySQLTODv_SourceFlow; CREATE OR REPLACE TARGET Microsoft_Dataverse_MySQLTODv_Target USING Global.MicrosoftDataverseWriter ( Tables: 'waction.test,DataverseTest keycolumns(Name) columnmap(Name=name)', tenantID: '<tenant ID>', refreshToken_encrypted: 'true', clientSecret_encrypted: 'true', adapterName: 'MicrosoftDataverseWriter', clientSecret: '<client secret>', refreshToken: '<refresh token>', connectionRetryPolicy: 'retryInterval=30, maxRetries=3', BatchPolicy: 'eventCount:999, Interval:60', clientID: '<client ID>', serviceRootURL: 'https://orgc4ca6c06.api.crm.dynamics.com/api/data/v9.2', CDDLAction: 'Halt' ) INPUT FROM MySQLTODv_OutputStream; END APPLICATION MySQLTODv;