Connecting to SendGrid via SQL

You can use SQL to connect to SendGrid in the CData Virtuality Studio or the Code Editor in the Web UI.

Pre-requisites

You need the AccessToken.

How to Connect

Run the following statements in the CData Virtuality Studio or the Web UI (remember to enter your credentials):

SQL

CALL SYSADMIN.createConnection (
     name => 'sendgrid_src',
     jbossCliTemplateName => 'ws',
     connectionOrResourceAdapterProperties => 'EndPoint=<EndPoint>,AccessToken=<AccessToken>',
     encryptedProperties => ''
);;

CALL SYSADMIN.createDatasource (
     name => 'sendgrid_src',
     translator => 'sendgrid',
     modelProperties => '',
     translatorProperties => '',
     encryptedModelProperties => '',
     encryptedTranslatorProperties => ''
);;