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 SystemSAS Cloud Data Exchange Eco System. SAS Cloud Data Exchange CLI.Co-located and Remote Data Agent ConfigurationConfigure 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-SetsConfigure SAS Data-Sets Data Source. Access SAS Data-Sets from SAS Compute Server. Access SAS Data-Sets from CAS.Access Oracle DatabaseConfigure Oracle Data Source. Access Oracle Data Source from SAS Compute Server. Access Oracle Data Source from CAS.Access Federated Data SourceConfigure Federated Data Source. Access Federated Data Source from SAS Compute Server. Access Federated Data Source from CAS.Access DB2 DatabaseConfigure DB2 Data Source. Access DB2 Data Source from SAS Compute Server. Access DB2 Data Source from CAS.Access MS-SQL Server DatabaseConfigure 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 AppsCloud Data Exchange ODBC Driver for 3rd-party apps. Cloud Data Exchange ODBC CAS Driver for 3rd-party apps.
|