SAS® Viya®: Cloud Data Exchange
START FREE TRIAL
Available in:
Education Category Image


  
SAS® Viya®: Cloud Data Exchange
Duration: 14 hours
DE326W : DE326A
The SAS Cloud Data Exchange enables SAS users to connect and access data from a co-located database or from an on-premises database. The Cloud Data Exchange enables users to securely exchange on-premises data from behind a firewall to the SAS Viya platform in the cloud. All data transfer/exchange occurs on secured standard-based communications along with sophisticated authentication and authorization. The on-premises data center requires a single port opened through the firewall to facilitate the data exchange.
Learn How To
  • Deploy and configure co-located Data Agent and Remote Data Agent.
  • Create custom SSL cert for Remote Data Agent Server.
  • Verify secured connection between co-located Data Agent and Remote Data Agent.
  • Create SAS Data Sets Data Source and access from SAS Compute Server and CAS.
  • Create Oracle Data Source and access from SAS Compute Server and CAS.
  • Create Federated Data Source and access from SAS Compute Server and CAS.
    • Who Should Attend
    Technical Architects
    Prerequisites
    Before attending this course, you should be familiar with the Unix environment and Unix commands.
    SAS Products Covered
    SAS Viya
    Course Outline
    Introduction
  • Introduction to SAS Cloud Data Exchange.
  • Environment guide.
  • Validate workshop environment.
    • SAS Cloud Data Exchange Eco System
  • SAS Cloud Data Exchange Eco System.
  • SAS Cloud Data Exchange CLI.
    • Co-located and Remote Data Agent Configuration
  • Configure co-located Data Agent.
  • Create remote Data Agent encryption certificate.
  • Deploy and configure remote Data Agent.
  • Verify co-located to remote Data Agent network access.
  • Register remote Data Agent.
    • Access SAS Data-Sets
  • Configure SAS Data-Sets Data Source.
  • Access SAS Data-Sets from SAS Compute Server.
  • Access SAS Data-Sets from CAS.
    • Access Oracle Database
  • Configure Oracle Data Source.
  • Access Oracle Data Source from SAS Compute Server.
  • Access Oracle Data Source from CAS.
    • Access Federated Data Source
  • Configure Federated Data Source.
  • Access Federated Data Source from SAS Compute Server.
  • Access Federated Data Source from CAS.
    • Access DB2 Database
  • Configure DB2 Data Source.
  • Access DB2 Data Source from SAS Compute Server.
  • Access DB2 Data Source from CAS.
    • Access MS-SQL Server Database
  • Configure MS-SQL Data Source.
  • Access MS-SQL Data Source from SAS Compute Server.
  • Access MS-SQL Data Source from CAS.
    • CDE ODBC and CAS Driver for 3rd-Party Apps
  • Cloud Data Exchange ODBC Driver for 3rd-party apps.
  • Cloud Data Exchange ODBC CAS Driver for 3rd-party apps.
    		•
    THIS COURSE IS PART OF

    SAS Architecture and Security Learning Subscription



    Skip Earn this badge

    Earn this badge

    Badge Image