Database Management

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.

  • Data Export

    All Products

    This 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 Traffic

    This 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 Traffic

    This 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 Traffic

    This 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 Traffic

    This 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 Radio

    This 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 Traffic

    A 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

Interested in working with a WideOrbit expert? Let’s talk.