Create 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 Request 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.

If you are connecting to a data source that resides outside of the IU Data Center, consider encrypting the connection.

This is document ankv in the Knowledge Base.
Last modified on 2018-04-25 10:59:38.

Contact us

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