Course outline

Cisco Information Server Basic

Categories: Cisco, Guaranteed To Run™

Duration: 5 Days

This 5-day, instructor-led course addresses engineers and administrators who are familiar with data integration, but do not have experience with Cisco Data Virtualization technology. This course includes hands-on accelerated training on installing and developing with Cisco Information Server Application Data Services. It provides technical guidance to engineers who will be performing complex integration activities.

  • Be familiar with the principles of data virtualization
  • Learn the skills necessary to implement data virtualization including data source introspection views, procedures, publishing
  • Understand governance topics such as query optimization, caching, security
  • Understanding of databases in general
  • Understanding of SQL concepts with the ability to develop in SQL
  • Basic Windows skills
  • Understanding of Web Services
  • Data Engineers
  • Solution/BI Architects
  • Administrator(s)
  • Data Architects

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

Feel free to contact us, if you want to know the price and location of this course. A Digital Revolver representative will contact you shortly to help you with your inquiry.
Please fill out the form below

  • Guaranteed to Run™. This ensures you will attend the instructor led class or live online class you want as scheduled without any disruptive cancellations*. You book the training you need, get back to focusing on your job and are sure your training requirements will be met saving time, money and ensuring peace of mind.
  • This schedule icon the schedule indicates that this date/time will be conducted as Instructor Led Training (ILT) or a Virtual Instructor Led Training (VILT) depending on the indicated class availablity.
Privacy and Cookies

This website stores cookies on your computer which help us make the website work better for you.

Learn moreAccept and Close
Social media & sharing icons powered by UltimatelySocial