Connection management

Each time you start the add-in for Excel, you must create a connection.

The connections feature lets you manage and connect to multiple Autonomous Databases with a single add-in. Multiple connections can be created. However, only one connection can remain active.

The connection panel lets you connect to the Autonomous Database through a connection where you provide the login credentials and access the Autonomous Database.

Within the Connections panel, you can:

• Create or delete multiple connections using a single add-in.
• Share connection information by exporting and importing connection information to a file.
• View existing connections.

Selecting Connections opens the Connections wizard.

Note:

This is an implicit type of connection. Refer to Authenticate using Implicit connection to understand more about implicit connection.

The Connections wizard consists of Manage Connections icon that has the following options available:

• Add Connection: Select Add Connection to Add a Connection. Refer to Add a Connection section for more details.
• Export Connection: Select Export Connection to export connections. Refer to the Share a Connection section for more details.
• Import Connection: Select Import Connection to launch the import wizard to choose a connection file. These files are in JSON format.