Semrush

Semrush creates software products for search and marketing professionals. Features include keywords research, SEO metric comparison, advertising research, and comparison of competitors organic positions. The Semrush API allows users to pull automated data from the SEMrush servers.

How to Connect

There are two ways to connect to Semrush: via the Sources connection wizard in the Web UI (recommended), or using SQL statements in the CData Virtuality Studio or the Code Editor in the Web UI. Here, we describe the first way; for the second way, see the subpage.

1. Go to the Sources tab and click + New Source:

2. Find the Semrush button in the list of connectors or type ‘semrush’ in the search field and select it:

3. Click the button, change the datasource name if necessary, enter your Access Token, and click 'Connect':

Usage

The SEMrush API connector introduces a new virtual schema semrush that contains the following stored procedures:

In addition to these public API procedures there are numerous views in the semrush_examples virtual schema that shows an exemplary usage of the public API:

If not needed, you can delete all the example views directly by dropping semrush_examples.