Connecting to Semrush via SQL

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

Pre-requisites

You need to get an identification key assigned to a user after subscribing to SEMrush that is available on the Profile page.

How to Connect

Before you start retrieving data, you need to run the connector script for Semrush in the Data Virtuality Studio or the Web UI and input your credentials in the following line:

SQL

CALL SYSADMIN.createConnection (
    name => 'semrush_src'
    ,jbossCLITemplateName => 'ws'
    ,connectionOrResourceAdapterProperties => 'EndPoint=http://api.semrush.com/'
);;


CALL SYSADMIN.createDataSource (
    name => 'semrush_src'
    ,translator => 'semrush'
    ,modelProperties => 'key=<key>,logs_backend_url=http://logs.backend.semrush.com/'
    ,translatorProperties => ''
);;