Creating Denodo data sources

Important:
Create Denodo data source connections using a group account, departmental account, or other shared account, not a personal account. For more about group accounts, see Requesting IU computing accounts for groups or departments.

To connect to your data sources, Denodo will initiate an outbound connection from the following URLs and IPs; you may need open firewall ports to make your data source accessible from these IPs:

  • DEV: esdsi02.uits.iu.edu (134.68.27.204)
  • STG: esdsi03.uits.iu.edu (134.68.26.79)
  • PRD1: esdsi04.uits.iu.edu (129.79.210.38)
  • PRD2: esdsi05.uits.iu.edu (129.79.210.59)

The descriptively named URLs (ebidvt-dev.uits.iu.edu, ebidvt-stg.uits.iu.edu, and ebidvt.uits.iu.edu) point to the load balancing servers used for incoming connections to Denodo.

Each type of data source connection has different options. Most connections to relational databases should use JDBC connections. There are many drivers available for JDBC connections (e.g., Microsoft SQL, MySQL, Oracle, Hadoop, Hive Redshift). To install a JDBC driver not listed here, contact EDSS.

You may also want to connect to Excel, Delimited, JSON, Webservice, LDAP, or XML data sources, or to Box, GitHub, or other web sources. For assistance with these connections, contact EDSS, as it is likely that another group at IU has already connected to a similar type of data source.

This is document ankv in the Knowledge Base.
Last modified on 2016-11-04 12:36:53.

  • 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.