Integrating SAS  Teradata

Integrating SAS Teradata PowerPoint PPT Presentation


  • 240 Views
  • Uploaded on
  • Presentation posted in: General

Download Presentation

Integrating SAS Teradata

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


1. Integrating SAS & Teradata Past – Present - Future

2. 1 Discover Financial Services Leading Credit Card Issuer and Electronic Payment Services Company Issuer of the Discover Card Pioneer of Cash Rewards Payment Services – Credit, Debit & Prepaid Discover Network PULSE ATM/Debit Network Diners Club International Alliances China Union Pay JCB BC card Discover Bank Savings/CD’s Money Market Personal Loans Student Loans

3. 2 SAS @ Discover

4. 3 Teradata @ Discover

5. 4 Common SAS Implementation

6. 5 Achieving Symbiotic Relationships

7. 6 In Retrospect Our Key Decisions

8. 7 Legacy SAS Infrastructure Disadvantages Scalability Hardware Failure Risk Expensive DR Disruptive Upgrades 2010 presented opportunity to build 3rd Generation SAS Environment Grid implemented in April 2010

9. 8 Grid Architecture New Hardware/Storage Infrastructure Typically low-cost servers Ability to scale out as environment/user base grows SAS Grid Computing Management/Governance of SAS Workloads Prioritization (Queuing) capability High Availability Configuration SAS Version Upgrade – SAS 9.1.3 to SAS 9.2

10. 9 Benefits Hot fixes & rolling server reboots with no impact to users Workload Balancing with Rules-Based Prioritization Horizontal scalability Co-Location of SAS Grid environment with Teradata Run Time Improvements: Key Segmentation Model: 4 hour 50 minutes to 1 hour 47 minutes Critical Marketing Model: 9 hours 7 minutes to 3 hours 35 minutes

11. 10 Grid Lessons Learned Chart existing utilization patterns Strong Unix Operations/Administration support Plan for adjustment of jobs to take advantage of Grid parallelism Establish Power User Group

12. 11 What’s Next? Tune & Optimize Grid and Expand as needed Next Generation of Training and internal SAS/Teradata User Group DR Capability Implement SAS 9.2 M3 Grid Performance Charting/Optimization Explore SAS In-Database Procedures on Teradata v13

13. 12 Future State

14. 13 Primary Challenge to the Future State

15. 14 Questions

  • Login