Cadeon TIBCO Data Virtualization Fundamentals Agenda:
Day 1 - TIBCO DATA VIRTUALIZATION
- Overview of Data Virtualization
- Best Practices - the Hierarchy of Folders
- Importance of Data Architecture Design - using the Studio
- Data Source Connections and the power of "Introspection"
- Data Discovery - Discovering Relationships between DB Data Sources
- Using “Introspection” and “Discovery” to establish and use relationships between EXCEL and other file-based Data Sources
- Using Views to create an effective Data Virtualization Source structure
- Building Views and Publishing the Output from ADS (to Spotfire)
Day 2 - TIBCO DATA VIRTUALIZATION (continued)
- Building Views in TDV
- using Parameterized Queries
- using SQL Scripts in TDV
- using Packaged Queries in TDV
- Handling XML Data using the Transformation Editor
- An Overview of Caching, Security & Trouble Shooting
- The Query Engine - Using the Execution Plan for effective Query Performance
- The Data Lineage tool - Using Data Lineage for Data tracking and Impact Analysis
- Using Additional Data Source Connectors
Day 2 (cont) - TIBCO BUSINESS DIRECTORY
- Business Directory – An Introduction to using TIBCO Business Directory
- Creating Sites
- Using the Browse Menu
- Using the Admin Menu
- Using Categories and Custom Properties to “tag” TDV Data for Business use
- Access Controls
