Connecting to Box

Concept Information

ACCESSDATA command

Box is a cloud-based content management service, which enables file sharing and collaboration for business. You can use the Box data connector to import your organization's Box data .

Note

The Box data connector is provided by our data partner, CData. For information about any of the connection fields, refer to the documentation available at the CData website.

Before you start

To connect to Box, you must gather the credentials to connect to the Box server.

For help gathering the connection prerequisites, contact the Box administrator in your organization. If your administrator cannot help you, you or your administrator should contact Box Support.

Create a Box connection

  1. From the Analytics main menu, select Import > Database and application.
  2. From the New Connections tab, in the ACL DSN Connectors (Bundled) section, select Box.

    Tip

    You can filter the list of available connectors by entering a search string in the Filter connections box. Connectors are listed alphabetically.

    The DSN Configuration dialog box appears.

  3. In the DSN Configuration dialog box, click Test Connection.

    The Box Log in page appears.

  4. To log in:
    • If you have the Box account credentials, provide the credentials.
    • If your organization uses SSO, click Use Single Sign On (SSO).
  5. Click Authorize.

    If you are using SSO, provide the credentials and log in.

  6. On the page that appears, click Grant access to Box.

    The page is authorized successfully.

  7. Click OK in the connection successful dialog box that appears.

    The connection to Box is established successfully.

  8. In the DSN Configuration dialog box, click OK.

The connection for Box is saved to the Existing Connections tab with the connection name as Box. In future, you can reconnect to Box using the saved connection.

Once the connection is established, the Data Access window opens to the Staging Area and you can begin importing data. For help importing data from Box, see Working with the Data Access window.

Note

When connected to Box through multi-factor authentication (MFA), the authentication token expires roughly after one hour and causes any existing connections and imports happening to fail. Once the authentication failure happens, the existing connection will not work. You must create a new connection to Box for your further operations.

Rename the connection

When you create the Box data connector, you cannot provide a Connection name of your choice and the connection is saved to the Existing Connections tab with the same name as your data source. If you want to rename it, navigate to the Existing Connections tab, expand the ACL Connectors (DSN) section, click the ellipsis icon corresponding to Box and select Rename connection.