Connect DBeaver to EmailOctopus and access data

Accessing a EmailOctopus database can be fast and seamless with an Open Database Connectivity (ODBC) solution. Devart ODBC Driver for EmailOctopus provides full interoperability and allows you to access live EmailOctopus data. The driver enables you to retrieve, view, and modify EmailOctopus data directly within DBeaver.

Step 1. Install the ODBC driver and set up a data source (DSN)

Install Devart ODBC Driver for EmailOctopus and configure a data source (for instructions, see below). To prevent the incorrect display of the SQL_WVARCHAR data type in DBeaver, set String Types to Ansi on the Advanced Settings tab of the configuration dialog.

Install the ODBC driver and set up a data source (DSN)

Step 2. Create a new connection

In DBeaver Enterprise, go to Database > New Database Connection, select ODBC, and click Next. Connecting to EmailOctopus in DBeaver Community is also possible but requires manual configuration using a generic ODBC connection (for more information, see our documentation).

Create a new connection

Step 3. Enter the connection settings

In Data Source, select your DSN. Click Test Connection to verify that the connection details are valid. Click Finish.

Enter the connection settings

Step 4. View EmailOctopus data

EmailOctopus data is now available in DBeaver. To view a table, expand the database structure and click the needed table.

View ${driverName} data

Step 5. Query EmailOctopus data

Go to SQL Editor > New SQL script, enter your query, and then click SQL Editor > Execute SQL query. The query results are displayed in the main window.

Query ${driverName} data

How to download, install, and configure Devart ODBC Driver for EmailOctopus

  • Windows

Download the driver

Click Download in the upper-right corner of this page. Under Download for Windows, click Download next to the EXE or MSI file or—if you're not signed in—click Get Trial, sign up or sign in to your Devart account, and then click Download next to the needed file.
Download 30-day Trial

Install the driver

Run the downloaded installer. Click Next and follow the instructions.

Install the driver

Start the trial period or activate the driver

If you don't have an activation key yet, select Trial; if you've already purchased a license, select Activation Key and enter your key. Then, click Next. To complete the driver installation, click Finish.

Start the trial period or activate the driver

Open ODBC Data Source Administrator

Click Start on the taskbar, type ODBC Data Sources, and select a matching result. The ODBC Data Source Administrator opens.

Open ODBC Data Source Administrator

Add a data source (DSN)

Go to the User DSN or System DSN tab and click Add. Select the driver and click Finish.

Add a data source (DSN)

Configure the data source (DSN)

On the General tab, enter a Data Source Name, Description, and other details required to connect to the data source.

Configure the data source (DSN)

Complete the configuration

Click Test Connection to make sure that all details are correct. Then, click OK to save the data source and complete the configuration.

Complete the configuration

Key Features

Cross-Platform Support

Platforms Variety

ODBC can be used with 32-bit and 64-bit applications on both x32 and x64 platforms

Performance Features

Performance Features

  • Connection pooling
  • Batch updates
  • Prepared statements
Unicode Support

Unicode Support

Full Unicode compliance for all character sets

Security Features

Security Features

  • SSL/TLS encryption
  • Custom certificate support
Connection Speed

Connection Speed

  • Direct TCP/IP connection
  • Optimized data transmission
Simple Deployment

Simple Deployment

  • Single driver installation, no additional components
  • Support for all EmailOctopus versions

Ready to get started?

Get started with ODBC Drivers at no cost

Get started with ODBC Drivers at no cost

Download a FREE, fully-functional 30-days trial version and elevate your database development and administration today!

Try ODBC Universal Bundle

Try ODBC Universal Bundle

Universal access to data of different ODBC compliant data sources. It supports most of major database servers and cloud services, including Salesforce, MySQL, Oracle, SQL Server and others.

Need a hand?

Need a hand?

If you need any help or have questions about our tools or purchasing options, just get in touch with our team.

Popular DBeaver Integrations Using ODBC Driver

  • All sources
  • Database
  • Cloud

We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.