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 Creating and using 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.

  • Fill out this form to submit your issue to the UITS Support Center.
  • Please note that you must be affiliated with Indiana University to receive support.
  • All fields are required.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.

  • Fill out this form to submit your comment to the IU Knowledge Base.
  • If you are affiliated with Indiana University and need help with a computing problem, please use the I need help with a computing problem section above, or contact your campus Support Center.

Please provide your IU email address. If you currently have a problem receiving email at your IU account, enter an alternate email address.