Connecting to Shopify via SQL

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

Pre-requisites

You need an access token.

How to Connect

You need the access token and the unique name of the store to gain access to API.

SQL

CALL SYSADMIN.createConnection (
	name => 'shopify_src', 
	jbossCLITemplateName => 'ws', 
	connectionOrResourceAdapterProperties => 'AccessToken=<AccessToken>,EndPoint=https://<storename>.myshopify.com/admin/api/2025-01'
);;

CALL SYSADMIN.createDataSource (
	name => 'shopify_src', 
	translator => 'shopify', 
	modelProperties => '', 
	translatorProperties => ''
);;