Database Management
Manage and improve the databases that support WideOrbit products.
Accurate and Relevant Data
Maintain data integrity and reduce liability through periodic data clean-ups or strategic migrations. WideOrbit experts will help ensure your data remains accurate and relevant.
Available Services
-
Data Export
All ProductsThis service gives you the ability to export files from WideOrbit products. For example, an export file could include revenue, billing, or payment data.
License Required: Yes
Exclusions: Data retained in products not listed above. Data cleanup. GL Export -
Data Purge
WO Analytics, WO Media Sales, WO TrafficThis service allows you to delete data from your database that you no longer need. WideOrbit recommends you do this periodically to minimize the size of the database and reduce liability.
License Required: No
Dependencies: Specified date for past records deletion. You should ensure any deletions are in line with your data retention policies.
Exclusions: Data retained in products not listed above -
Database Migration
WO Media Sales, WO Network, WO Omni, WO TrafficThis service allows WideOrbit to migrate your database onto new hardware.
License Required: No
Inclusions: The new database is fully installed and configured to work with the WideOrbit system
Exclusions: Data cleanup, including a database purge and/or scrub -
Database Refresh
WO Media Sales, WO Network, WO Omni, WO TrafficThis service supports a periodic update to the data in your non-production database with more current data from your production environment.
License Required: No
Dependencies: Your production data is complete and clean
Inclusions: The first six database refreshes are included. Each refresh thereafter will be billed separately.
Exclusions: Data cleanup -
Database Script
WO Media Sales, WO Network, WO Omni, WO TrafficThis service allows WideOrbit to create and run a database script in your environment to complete tasks that are not available through a user interface and not the result of a WideOrbit software defect.
License Required: No
Dependencies: The Production data is complete and clean
Exclusions:
• Database migration
• Data refresh for a lower environment
• Data cleanup
• Automation scripts -
Database Script – WO Automation for Radio
WO Automation for RadioThis service creates and runs a script when you need to update data in your WO Automation for Radio database.
License Required: Yes
Dependencies:
• Central Server
• Postgres
Inclusions: PGAdmin -
Database Scrub
WO Network, WO Omni, WO TrafficA database scrub deletes data in a WideOrbit product that’s associated with specific properties. Use this service during station sales to create a new database for the buyer and a database for the seller, without the “scrubbed” properties. This is typically used during acquisitions and divestitures.
License Required: No
Exclusions:
• Data cleanup
• Data refresh for a lower environment
Learn More about Managed Services
Interested in working with a WideOrbit expert? Let’s talk.