SAS® Viya®: Cloud Data Exchange
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 CLI.
- 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.
- Configure SAS Data-Sets Data Source.
- Access SAS Data-Sets from SAS Compute Server.
- Access SAS Data-Sets from CAS.
- Configure Oracle Data Source.
- Access Oracle Data Source from SAS Compute Server.
- Access Oracle Data Source from CAS.
- Configure Federated Data Source.
- Access Federated Data Source from SAS Compute Server.
- Access Federated Data Source from CAS.
- Configure DB2 Data Source.
- Access DB2 Data Source from SAS Compute Server.
- Access DB2 Data Source from CAS.
- Configure MS-SQL Data Source.
- Access MS-SQL Data Source from SAS Compute Server.
- Access MS-SQL Data Source from CAS.
- Cloud Data Exchange ODBC Driver for 3rd-party apps.
- Cloud Data Exchange ODBC CAS Driver for 3rd-party apps.
Live Class Schedule
Duration: 14 hours
Step into our live classes and experience a dynamic learning environment where you can ask questions, share ideas, and connect with your instructor and classmates. With on-demand lab hours, you can explore the material at your own pace. Our globally acclaimed instructors will motivate you to think bigger, so you can take what you've learned and achieve your biggest goals.
This course isn't publicly scheduled, but private training and mentoring may be available. Contact us to explore options.
Private Training
Get training tailored specifically for your team, led by expert SAS instructors. Choose from virtual sessions, or training at your location (or ours). Perfect for teams seeking a customized curriculum and plenty of interaction with a SAS specialist. We'll schedule it at a time that works for you.
Mentoring Services
Take your training to the next level with personalized mentoring. While private training offers structured coursework, mentoring provides hands-on, real-time support from a subject matter expert. As you work with your own data, you'll receive expert guidance to help you uncover insights, unlock the full potential of your data, and make faster progress. Perfect for those looking to apply what they’ve learned and see quicker results.