> > > ANCISB Detailed outline

Cisco Information Server Basic (ANCISB)

Detailed Course Outline

Module 1: Introduction to the Cisco Information Server

  • Product Overview
    • Business and Technical Challenges for Enterprise
    • Deployment Options
    • Data Virtualization Architectural Overview
    • Data Virtualization Suite Components
  • Installing Cisco Information Server
    • Requirements
    • Installation on Windows
    • Installation on Linux
    • Post installation tasks
    • Patching
    • Log files and executables
    • Configuration
  • Data Abstraction with Cisco Information Server Studio
    • Logging into the Cisco Information Server with Studio
    • Data abstraction conceptual design
    • Implementing data abstraction design concepts

Module 2: Connecting and Transforming Data

  • Accessing basic data sources
    • Types of data sources
    • Defining data sources
    • Metadata filters
    • Revise introspection choices
    • Advanced data source properties
    • Data source adapters
  • Using Cisco Information Server Discovery
    • Discovery architecture
    • Discovery workflow
    • Configuring Discovery
    • Discovery task panel
    • Working with models in Discovery
    • Creating views in Discovery
  • Using Cisco Information Server views
    • Introducing views
    • Creating views
    • Using the model panel
    • Using the SQL panel
    • View execution
    • Identifying resources
    • Model regeneration
    • Using the grid panel
    • Client metadata

Module 3: Publishing

  • Introduction to publishing
  • Types of resources that may be published
  • Where to publish
  • Publishing as a database
  • Publishing as a web service
  • Contract first web services
    • Service-Oriented Architecture Approach
    • Cisco Information Server SOAP Services
    • Service Implementation Process
    • Create a WSDL Definition Set
    • Define a contract first web services

Module 4: Procedures

  • Parameterized queries
    • About procedures
    • Creating parameterized queries
    • Specify parameters
    • Execute parameterized queries
  • Basic SQL scripting
    • Control inputs and outputs with cursors and pipes
    • Control execution flow
    • Manage exceptions
  • Packaged queries
    • Introduction to packaged queries
    • Creating a packaged query
    • Required and optional parameters
    • Executing a packaged query
  • XML transformations
    • XML data and relational data
    • Types of XML transformation available in Studio
      • Tabular
      • XSLT
      • XQuery
      • Publishing

Module 5: Operate

  • Using Cisco Information Server Manager
    • Overview
    • Access
    • Navigation
    • Monitoring and logging
    • Server management
  • Basic security
    • Introduction
    • Securing data sources
    • Server security
    • Users and groups
    • Rights and privileges
    • Change owner
    • Security and data abstraction best practices
  • Basic caching
    • Benefits
    • Mechanisms
    • File cache
    • Database cache
    • Procedure cache
    • Cache architecture
    • Best practices
  • Basic query engine
    • Introduction
    • Push optimization
    • Execution plans
    • Join algorithms
    • Optimizer hints
    • Case sensitivity and trailing spaces

Module 6: Adapter Bundles

  • Adapter bundles for social media platforms
    • Architecture
    • Installation and configuration
    • Creating Facebook data sources
    • Creating Twitter data sources
    • Creating RSS data sources
  • Initiating OAuth
    • Introduction
    • Cisco Information Server and OAuth
    • OFF mode
    • GETANDREFRESH mode
    • REFRESH mode
  • SAP adapter bundle
    • Architecture
    • Installation and configuration
    • SAP R3 data sources
    • SAP BW data sources
    • OLAP views
    • SAP BE data sources
  • CRM and ERP adapter bundles
    • Architecture
    • Installation and configuration
    • Siebel data sources
    • Salesforce.com data sources
    • Oracle E-Business data sources
    • NetSuite data sources
    • Microsoft Dynamics CRP data sources
    • Microsoft Dynamics GP data sources
    • Microsoft Dynamics NAV data sources
  • NoSQL and Cloud database adapter bundles
    • Architecture
    • Installation and configuration
    • Creating Amazon DynamoDB data sources
    • Creating Google BigQuery data sources
    • Creating MongoDB data sources
  • Marketing automation adapter bundle
    • Architecture
    • Installation and configuration
    • Create Google AdWords Data Sources
    • Google Analytics Data Sources
    • HubSpot Data Sources
    • Marketo Data Sources
    • Oracle Eloqua Data Sources
  • Collaboration adapter bundle
    • Architecture
    • Installation and configuration
    • Email Data Sources
    • Google Apps Data Sources
    • Google Sheets Data Sources
    • Active Directory Data Sources
    • SharePoint Data Sources
    • SharePoint Excel Services Data Sources

Module 7: Platform Experience

  • Using Business directory
    • Accessing
    • Browsing resources
    • Searching resources
    • Managing custom properties
    • Data lineage
    • User profile
    • Assigning categories
    • Adding comments to resources
  • Basic troubleshooting
    • Overview
    • Tools
    • Common error scenarios
    • Documentation

Labs

  • Cisco Information Server Installation
  • Cisco Information Server Studio Best Practices
  • Using Basic Data Sources
  • Cisco Information Server Discovery
  • Create SQL Views
  • Publishing
  • Contract First Web Services
  • Using Parameterized Queries
  • Create and Test Basic SQL Script
  • Packaged Queries
  • XML
  • Basic Security
  • Basic Caching
  • Query Engine
  • Basic Troubleshooting