MSAMM
Back to course

Administering Cloud EPM: The Platform Beneath the Business Processes · Module 11 · Automation

Scripting patterns: data load and refresh

Lesson 127 of 201 · 13 min

Build a load script: sign in, upload the file, run the import job, refresh, sign out. Add a check that the file exists before uploading. Add a check on job status before proceeding to the next step. Run it and show it succeeding, then break it deliberately — a bad file — and show it failing at the RIGHT step. CHECK BEFORE YOU ACT, AND CHECK AFTER. A script that uploads a missing file and refreshes anyway has done something WORSE than nothing. SEQUENCE MATTERS. Load, then import, then refresh. Getting it wrong produces a refresh of yesterday's data with today's timestamp — the kind of error nobody catches for a month. The deliberate failure is the lesson. It shows what a well-built script does when the world is wrong.

The full lesson is part of the course

The video, the complete written lesson and the module quiz are included in Administering Cloud EPM: The Platform Beneath the Business Processes, with a certificate on completion and a fourteen-day refund window.

See the course and enrol9 free lessons

Get the free lessons by email

We will email you a link to every free lesson in this course. No account needed, and one message only.

In this module: Module 11 · Automation

  1. 1Three tools, one questionFree preview
  2. 2Job Scheduler
  3. 3Installing and configuring the automation utility
  4. 4Authentication and credential handling
  5. 5The command surface
  6. 6Scripting patterns: backup and export
  7. 7Scripting patterns: data load and refresh
  8. 8Error handling and logging
  9. 9Scheduling and service accounts
  10. 10REST APIs and when to reach for them
  11. 11The integration agent
  12. 12What breaks
  13. 13Lab: automate it, and write the runbook