Connecting to Emarsys via SQL

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

Pre-requisites

You need the username, password.

How to Connect

Before you start retrieving data, you need to run the connector script for Walmart Marketplace in the CData Virtuality Studio or the Web UI and enter your credentials in the following lines (remember to adjust the endpoint in the following line: EndPoint=http://suite7.emarsys.net/api/v2 to the endpoint which you got from Emarsys):

SQL

CALL SYSADMIN.createConnection (
    name => 'emarsys_src'
    ,jbossCLITemplateName => 'ws'
    ,connectionOrResourceAdapterProperties => 'EndPoint=http://suite&#60;number>.emarsys.net/api/v2'
);;
 
CALL SYSADMIN.createDataSource (
    name => 'emarsys_src'
    ,translator => 'emarsys'
    ,modelProperties => 'USERNAME=<USERNAME>,SECRET=<SECRET>,ParentDirectory=<ParentDirectory>'
    ,translatorProperties => ''
);;

ParentDirectory corresponds to an arbitrary folder on the file system, and is only used in the uploadFile procedure, being the folder to search for such files.