Establishing a Connection

Configure a Connection Profile

From the CData ribbon, click Get Data and select From Suadeo connection/s to launch the CData Query window. To setup a new connection, you will have to click the New Suadeo Connection button. Here you can set the connection settings, test the connection, and save the connection profile.

Connecting to Suadeo

The add-in uses the OAuth 2.0 Resource Owner Password Credentials (ROPC) grant for authentication. This method allows you to authenticate with Suadeo using your username and password to obtain an access token.

How Authentication Works

When you connect, the add-in automatically:

Sends your username and password to the Suadeo OAuth token endpoint
Receives an access token in response
Uses the access token to authenticate all subsequent API requests
Automatically obtains a new access token when needed during the session

Note: Unlike some OAuth implementations, Suadeo does not use a browser-based authorization flow or refresh tokens. Authentication occurs directly using your credentials, and the access token is active only for the duration of the connection session.

Required Connection Properties

To connect to Suadeo, you must set the following properties:

URL: The base URL of your Suadeo instance.
User: Your Suadeo username.
Password: Your Suadeo password.
AuthenticationName: The name identifier for the authentication configuration in your Suadeo instance. Different authentication names can be configured for different environments or use cases.

Note: The Schema connection property is not required to connect to Suadeo.

Connection Properties

The Connection properties describe the various options that can be used to establish a connection.

Managing Connections

After successfully authenticating to Suadeo you will be able to customize the data you are importing. To learn more about this, see Managing Connections.

Excel Add-In for Suadeo