View Categories

Requirements and checklist before use

Before you start using DataBridge, please check the requirements and the supported file types and platforms that you are planning to use. The listed features might be available depending on the subscription that you chose.

DataBridge

Before you subscribe to any of the DataBridge Plans, you are free to test-drive DataBridge. Sign up here to start your DataBridge journey without a subscription. All about the different subscription plans and the free trial subscription can be found here.

SuperOffice CRM

  1. SuperOffice CRM subscription (online or onsite). Check here for specific requirements for SuperOffice Onsite.
  2. SuperOffice CRM user with the General Administrator role.

Import file

  • Local file (manual upload)
  • Google Drive
  • Dropbox
  • OneDrive
  • Sharepoint
  • FTP
  • Email (Microsoft 365 or IMAP)
  • Google Sheets

Export file

  • Google Drive
  • Dropbox
  • OneDrive
  • Sharepoint
  • FTP
  • Email
  • Google Sheets

File types

DataBridge supports the following file types for the given source files.

  • CSV – txt, csv, tsv
  • Spreadsheet – xlsx, xlsm, xltx, xltm, xls, ods
  • XML – xml
  • Google – gsheet
  • EML – email

SQL Database

  • Microsoft SQL Server 2016 (aka SQL Server 12) and newer
  • Azure SQL Database

The supported authentication methods are:

  • For Microsoft SQL Server: SQL Server Authentication
  • For Azure SQL Database: SQL Server Authentication or Azure Active Directory

SQL Database security

A user is needed with sufficient rights to connect to the SQL Server instance, access the database and to create, edit and delete tables. The user must have rights to insert, update and delete records in the table.
Besides the SQL roles db_datareader and db_datawriter, the db_ddladmin role is also needed, as the db_datawriter role is not allowed to create/delete tables. The db_ddladmin role can create/delete tables but cannot do Select queries.

We don’t advise to use any users to connect with more rights than needed.

We advise to only whitelist the IP addresses that DataBridge uses. See the ‘Security’ section further on this page.

IMAP based email boxes

IMAP settings -like hostname, port, requires SSL, etc.- differ per email provider and can be found with the email providers. For private email servers, like Microsoft Exchange Server, the sysadmin should be able to provide these settings.

IMAP must be enabled. Depending on the email provider, it may or may not be enabled by default.

Gmail has extra layers of security.

An App password needs to be used, but therefore your account must first be set up to use 2 factor authentication: Turn on 2-Step Verification – Computer – Google Account Help
Once this is set up, an App Password can be created: Sign in with app passwords – Google Account Help This password should then be entered into the password field when setting up the profile in DataBridge.

Gmail might still block the connection in spite of this setting being enabled, and require the following extra step from users: https://accounts.google.com/b/0/DisplayUnlockCaptcha
In any case, check the troobleshooting guide: Add Gmail to another email client – Gmail Help

Known issues

Special characters & and ! are not properly supported by Gmail in the email subject and their use should be avoided. IMAP “search header” command failing when search-text contains exclamation mark (!), ampersand (&), etc

Browsers

We follow SuperOffice in which browsers we test and support. A list of tested and compatible browsers can be found here:

Security

For connections to (local or remote) databases, FTP servers and other platforms, DataBridge uses one of the following IP addresses. If you use whitelisting in your security setup, please add these.

20.123.176.149

40.118.68.234

40.118.69.16

40.118.69.95

40.118.64.32

213.124.69.170

DataBridge does not support adding certificates while connecting to your local or remote platforms.