Skip to main content

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;