Skip to main content
(opens in a new tab)
Filter your search by category. Current category:
All
All
Service Catalog
Search the client portal
Search
Sign In
Show Applications Menu
Illinois Tech Help Center
Sign In
Search
Home
About Us
Help Desks
Cybersecurity Incident
Services
More Applications
Service Catalog
Administrative and Business
System Offices Services
AITS - Data Integration and Virtualization (Denodo)
AITS - Data Integration and Virtualization (Denodo)
Show Help
For All Fields
Hide Help
For All Fields
Denodo Data Virtualization Service
Status
The status of the ticket. This indicates where the ticket is in its lifecycle.
New
Contact Information
Ticket Details
Subject
A short description to explain the nature of a ticket.
Request Type
Add Data Catalog Tags/Categories
Request Virtual Database
Safelist IP Address
Open Firewall to connect to a database
Add Active Directory Group to Virtual Database
Request a Scheduled Job in Denodo
Get Help (technical support/request consulting)
Virtual Database (VDB) Name
Purpose of Scheduled Job
Business need for the scheduled job. Will also be used to populate the job description in Denodo.
Data Source to be Used
Data source must be ODBC, JDBC, Elasticsearch, or VDP data source. No flat files allowed.
Queries to be used to extract data
Please upload a text file containing the queries to be used to extract data using the attachment field at the bottom of this form. These queries should query the views in your unit’s VDB, which BIA will then schedule to run in the Scheduler.
Is an Export Needed?
Is an Export Needed?
Yes
No
Export Format
CSV
Excel
Elasticsearch (7.X)
JDBC/ODBC
Host Machine
HTTP Port/Port of RESTful API
Database Adapter
Connection URI
Email Output?
Email Output?
Yes
No
Email Address(es)
Email Output?
Email Output?
Yes
No
Email Address(es)
Requested Schedule Times and Frequency
No jobs referencing an LDW view will be scheduled between 11 pm and 6 am due to the data warehouse being updated during that time.
Please provide the names of the tags or categories you wish to add
Data Classification
Please enter the data classification for your VDB. You should choose the highest classification for any of the data assets that will be in your VDB. See the following page for information on data classifications:
https://cybersecurity.uillinois.edu/data_classi...
High Risk
Sensitive
Internal
Public
Use this form to request a virtual database for your unit. If your unit already has a VDB you do not need to request another one.
Administrator's Active Directory Group DN
Provide the full distinguished name (DN) for the VDB Administrator Active Directory group. Membership of the Admin AD should only include administrators of the VDB. You can request additional AD groups for developers and consumers below. Please ensure the AD groups are created and the full DN is provided to avoid delays in processing your request. AD groups must exist in order for you to provide the full DN.
Please note the full DN cannot exceed 99 characters. Example: DN: cn=group name,ou=xyx,ou=abc,ou=lmnop,ou=groups,dc=ad,dc=campus,dc=edu
Additional Active Directory Group(s)
Provide the full distinguished name (DN) for additional active directory groups that will be used to provide access to developers and data consumers. Please note the full DN cannot exceed 99 characters.
Example: DN: cn=group name,ou=xyx,ou=abc,ou=lmnop,ou=groups,dc=ad,dc=campus,dc=edu
Use this form to request an additional Active Directory group to your existing VDB. Please note the full DN cannot exceed 99 characters.
Please ensure the AD groups are created and the full DN is provided to avoid delays in processing your request. AD groups must exist in order for you to provide the full DN.
New Active Directory Group DN
Example: DN: cn=group name,ou=xyx,ou=abc,ou=lmnop,ou=groups,dc=ad,dc=campus,dc=edu
Level of Access
Administrator
Developer
Viewer
Other
To which VDB should we assign access?
Safelisted servers should only be used for server or batch processing and not for interactive use. Interactive users are required to use the 2FA VPN. VDB development should be done on your local machine.
Provide the server name, IP address, and all ports for each server.
Host name
Example:
Host: apps.dept.campus.edu
Host server IP
Example:
IP: 123.45.67.890
Host server port(s)
Example:
Ports: 3306; 6400-6430
Submit this form to request the outbound firewall be opened to connect to an externally-hosted, non-Illinois system database.
Host name
Example:
Host: apps.dept.campus.edu
Host server IP
Example:
IP: 123.45.67.890
Host server port(s)
Example:
Ports: 3306; 6400-6430
External database description
Example:
This database is hosted by xyz server and contains survey data used by {Unit} for analysis.
Submit this form to request assistance with Denodo.
Type of Assistance
Type of Assistance
One-on-One Consulting
Technical Support
Description
Please describe what you would like assistance with.
Additional Information
Use this section to provide any additional information that may help with the resolution of this ticket.
Press Alt + 0 within the editor to access accessibility instructions, or press Alt + F10 to access the menu.
Attachments & Screenshots
If you have a screenshot of the issue or an attachment, please add it here
Browse...
Other Fields
Your name
Your first name
Your last name
Your email address
Verification Code