How can I ensure that all my Yellowfin Business Intelligence artifacts are saved properly? You can accomplish this through the Export functionality in the Yellowfin application. To export artifacts from Yellowfin, navigate to your Administration panel and select Export.
Note - some of the images below are from an older version of Yellowfin but the process and workflow are the same.
1. Select the what items you wish to export:
- From the dropdown menu, select the artifact type (data sources, views, categories, etc). Based on your selection, you will be presented with a list of artifacts to choose from.
- Tick the checkboxes of the artifacts you wish to export and click the Add button.
- Repeat the previous step for additional artifacts of a different type if needed.
- Click Next to continue.
2. Select the dependent artifacts:
If you have chosen to export artifacts which have dependencies, i.e a dashboard tab, Yellowfin will prompt you with a list of dependent artifacts (the reports in the dashboard tab, etc) which you may wish to export as well. To accomplish this:
- Tick the checkboxes for the dependent items.
- Click Add. This action will add them to the list of artifacts to export.
- Click Export
For reference, the Yellowfin artifact dependency structure is depicted in the diagram below:
3. Save the generated XML export file:
Clicking on Export will result in Yellowfin generating an XML export file which has all of your selected artifacts. Save this file in a safe location, such as a check-in repository, production artifact folder or cloud drives.
So, ensure that you take advantage of Yellowfin’s Export feature, and practice frequent back-ups, in order to avoid the disaster that one of our clients nearly experienced.
4. Back-up duplication:
Abiding by back-up management best practice is essential. This means:
- Creating multiple duplications to local and external sources.
- Keeping levels of back-up, even if that is the last 14 days.
Remember, assuming your artifacts are safe with a single back-up copy is wishful thinking. SAFE means keeping multiple copies of critical files on different media. Whether it is databases, transaction logs or critical business files, you must always have a fallback position.
So, remember to:
- Back-up to local disks for the fastest recovery
- Back-up to an external central back-up server (SAN, Tape)
- Back-up to USB Portable Drives that can be easily unplugged and connected to another server should the primary server fail
- Back-up to tape – preferably locking the tapes in a fireproof box, or taking them offsite.
There are many ways to automate all of these protections from simple ROBOCOPY scripts, to enterprise level back-up software applications.
Put these general back-up and recovery best practices into action, and you’ll never exhaust your options when a recovery is needed.