Creating a new External Data connection

When creating a new External Data connection, you'll need to know the provider you want to use to connect to your data and the type of authentication you want to use.

Additionally, there are advanced properties that can be used to limit table/schema access and simplify longer table/schema names.

Client connections

Client connections are private connections that can only be used by the user who created the connection. Private reports that use this connection can be published to others, but the other users would need have a client connection with the same name for the report to work.

Authentication

DAS supports 2 different authentication types for client connections, Provider and OAuth 2.0.

Provider Authentication

This type of authentication uses the authentication method as defined by the configuration specified by the data provider.

OAuth 2.0 Authentication

OAuth 2.0 uses modern authentication methodologies which can include multi-factor support. Additional configuration settings are required for this type of authentication. See Creating an External Data connection using modern authentication

Other connection options

In addition to the options above, you can see other options such as Data Source selection, bit-ness and adding tables for home page searching. (See Other External Data options)