Connecting to Freshdesk via SQL
You can use SQL to connect to Freshdesk in the Data Virtuality Studio or the Code Editor in the Web UI.
Pre-requisites
You need the authorization username.
How to Connect
Run the following statements in the Data Virtuality Studio or the Web UI (remember to enter your credentials):
CALL SYSADMIN.createConnection (
name => 'freshdesk_src'
,jbossCLITemplateName => 'ws'
,connectionOrResourceAdapterProperties => 'EndPoint=https://<YourFreshdeskDomainName>.freshdesk.com/api/v2,SecurityType=HTTPBasic,AuthUserName=<AuthUserName>'
);;
CALL SYSADMIN.createDataSource (
name => 'freshdesk_src'
,translator => 'freshdesk'
,modelProperties => 'cleanupMethod=DELETE'
,translatorProperties => ''
);;