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):

SQL

CALL SYSADMIN.createConnection (
    name => 'freshdesk_src'
    ,jbossCLITemplateName => 'ws'
    ,connectionOrResourceAdapterProperties => 'EndPoint=https://&#60;YourFreshdeskDomainName&#62;.freshdesk.com/api/v2,SecurityType=HTTPBasic,AuthUserName=&#60;AuthUserName>'
);;
 
CALL SYSADMIN.createDataSource (
    name => 'freshdesk_src'
    ,translator => 'freshdesk'
    ,modelProperties => 'cleanupMethod=DELETE'
    ,translatorProperties => ''
);;