Connecting to Box files as Denodo data sources

Note:
Before you can connect to a file on Box at IU as a Denodo data source, you'll need to create an external Box password. For instructions, see Create and use an external password for IU Box.

To connect to a Box file as a Denodo data source:

  1. In Denodo, create a new data source of a type matching your file:
    File type Data source type Options
    Excel Excel
    XML XML
    JSON JSON
    CSV Delimited Column delimiter: ,
    Tab delimited Delimited Column delimiter: \t
    Text or logs Delimited Column delimiter: ~ or `
  2. In the "File location" or "Data route" field, select FTP / SFTP / FTPS Client:
    Denodo Virtual DataPort Administration Tool's configuration screen, connection tab
  3. Click Configure.
  4. Change the following options:
    • Login: Enter your complete IU email address.
    • Password: Enter the external Box password you created above.
    • URL: Use the following format:
        ftps://ftp.box.com:990/[Folder Name]/[Complete File Name]

      For example, ftps://ftp.box.com:990/PersonalDemo/Personnel Budget Report (1).xlsx.

      Denodo Virtual DataPort Administration Tool with Edit FTP Connection window displayed
  5. Click OK. Based upon your data type, you may have additional options; make selections as appropriate.
  6. Click Save.
  7. Click Create base view.

For assistance, contact EDSS.

This is document anll in the Knowledge Base.
Last modified on 2016-11-04 10:45:43.

Contact us

For help or to comment, email the UITS Support Center.