Connecting to NuoDB

Connecting to NuoDB

The SaveToDB add-in allows connecting to NuoDB tables, views, and stored procedures.

The add-in ships the NuoDB .NET data provider. So, you can use it from the box.

You can download the latest version at https://www.3ds.com/nuodb-distributed-sql-database.

ODBC connections are not supported.

Here is a sample of the Database Connection Wizard page where you can select the data provider:

Connecting Excel to NuoDB Database - Selecting Provider

Connecting to NuoDB Databases

Use the following server name format for NuoDB:

<Server name or IP-address>[:<Port>]

Here is a sample of the connection to the test database on the localhost:

Connecting Excel to NuoDB Database

Below is a sample of the connection to the test database on localhost port 48004:

Connecting Excel to NuoDB Database