...
What:
Connect BI Tool directly to data source
Report developer creates Tableau data source or Cognos data module
Report developer then creates reports off the Tableau data source or Cognos data modules
Pros:
Allows report developers to build Cognos or Tableau report prior to the data source being added the applicable Activity Hub(s)
Once the data source is available in the applicable Activity Hub(s), the reports can be re-pointed
Can be blended with Activity Hub views (may reduce speed of report)
Works best with on-prem servers
Both Pro & Con:
Maintenance of Tableau data source or Cognos data module is performed by Report developer
Cons:
May not be available for applications located in the cloud or Amazon Web Services (AWS)
May not meet UCSD Minimum Network Security Standards
A poorly written report can negatively impact the performance of the data source
Does not allow for data to be used by data integrations
May not use AH naming standards or BIA development standards
How:
Email busintel@ucsd.edu to request connection between data source server and BI tool
AND Email busintel@ucsd.edu to request your data source be added to the Activity Hubs
Short Term Solution
What:
Upload data via Excel or CSV to Cognos server directly or Tableau server directly
Pros:
Can be used immediately
Can blend with Activity Hub views (may reduce speed of report)
Good solution for historical data or data that rarely changes
Cons:
Must be manually uploaded by report developer
Does note allow for data to be used by data integrations
How:
AND Email busintel@ucsd.edu to request your data source be added to the Activity Hubs