Excel Data Bridge Logo

Your quick reference guide
to Excel Data Bridge.

Features

Excel Data Bridge is a quick and easy time saving option ideal if you’re spending too much time rekeying in data.

  • Saves time entering data into Sage; create and edit data in the familiar spreadsheets of Excel.
  • Simplifies and streamlines the routine data entry process.
  • Enables manipulation of data in Microsoft Excel; posts directly into Sage without rekeying data.
  • Instant validation feedback telling you if data entered correctly.
  • Users can browse data from Sage within Excel and follow set rules to ensure consistency.
  • Ability to ‘work offline’ whilst still able to browse data.
  • Improves the way your team deliver their tasks.

Compatibility

Sage 200 Professional 2023 R1
Sage 200 Professional 2022 R2
Sage 200 Professional 2022 R1
Sage 200 Professional 2021 R1
Sage 200cloud 2020 R2
Sage 200cloud 2020 R1
Sage 200cloud Summer 2019
Sage 200cloud Spring 2019
Sage 200cloud Winter 2018
Sage 200cloud Summer Remastered 2018
Sage 200cloud Summer 2018
Sage 200cloud Spring 2018
Sage 200cloud Winter 2017
Sage 200cloud Summer Remastered 2017
Sage 200cloud Summer 2017
Sage 200 2016 Remastered SP2
Sage 200 2016 SP2
Sage 200 2016 SP1
Sage 200 2016 OEM
Sage 200 2015 SP3
Sage 200 2015 SP2
Sage 200 2015 SP1
Sage 200 2015 OEM
Sage 200 2013 R2 SP1
Sage 200 2013 R2
Sage 200 2013 SP1
Sage 200 2013 OEM
Sage 200 2011 (SP5)

  • Sage 200 Partner Cloud

Requirements

System Requirements

  • Windows Server Operating System
    • 2008 SP2
    • 2008 R2
    • 2012
    • 2012 R2
    • 2016
    • 2019
  • 4 GB of memory
  • 600 MB free disk space
  • 100 MB database
  • Windows feature - Windows Identity Foundation 3.5
  • IIS 7.0 or higher
  • Microsoft SQL Server 2008 or higher (32 or 64 bit)
  • Microsoft SQL Server 2008 require the SQL native client 12 to be installed to allow our installation
  • Microsoft .NET framework 4.5.1 or higher (Including ASP.NET feature)

Client Requirements

  • 4 GB of memory
  • 100 MB free disk space
  • Microsoft Office Excel 2010 or higher
  • Microsoft .NET framework 4.5.1 or higher
  • Microsoft Windows 7 or higher

Network Requirements

Outbound connection to download installer from the Partner Portal link to software installer

Outbound

TCP

443

Excel DataBridge Installers

cacerts.digicert.com

Certificate and Publisher verification

Application (Server implementation)

Direction

Protocol

Port

Source

Destination

Description

Outbound

TCP

443

Excel DataBridge Server

licensing2.draycir.net

Licensing

Inbound Local

TCP-HTTP

*80/85/86/custom

Excel DataBridge Clients

Excel DataBridge Server

Excel DataBridge Server Application

Internal**

TCP

1433

Excel DataBridge Server

SQL Server**

SQL Databases

Internal**

UDP

1434

Excel DataBridge Server

SQL Server**

SQL Databases

*Port configured as per the customers specification, By default its 80.

** Excel DataBridge Server maybe installed on the same server as SQL server