In today’s technology landscape, no system can be an island unto itself. ON-AIR Pro™ with its broad array of features, addressing workflows for numerous departments, is no exception. ON-AIR Pro™ is regularly being integrated with many different systems.
When contemplating the many integration possibilities available, it’s important to understand the ways that it can be approached. For example, some things that impact integration are the types of technology used, reliability issues of such connections, and defining the business logic that drives the triggering actions that are needed.
Thought Development is able to work with you and your IT staff, as well as your 3rd party vendors, to accomplish similar integrations with new and emerging solutions. It’s important to note that while we may have already performed a connection with a particular software solution, almost all systems have flexibility in how they are configured. For any integration to be successful, it’s important to plan on analyzing the unique ways in which each system is being used within your company.
Program Scheduling Systems Integration
1. Import external Program Schedule into ON-AIR Pro™ (Requires ON-Schedule™ Plug-in)
Description: The goal of the integration is to populate the ON-AIR Pro™ system with Program Schedule information for possible use by many of ON-AIR Pro’s™ features: Such as building Work Order’s from Schedule, auto-display of program conflicts within production environment, and more.
Method | Trigger | Originated By | Data Source | Data Recipient |
File Based(XML, Excel, .tab, .csv…) | Scheduled / Manual | ON-AIR Pro™ Server /User | Program Scheduling System | ON-AIR Pro™ |
ODBC Query (SQL/Oracle) | Scheduled | ON-AIR Pro™ Server | Program Scheduling System | ON-AIR Pro™ |
Web Service (XML) | Scheduled | ON-AIR Pro™ Server | Program Scheduling System | ON-AIR Pro™ |
2. Import Program Ratings into ON-AIR Pro™ (Requires ON-Schedule™ Plug-in)
Description: The goal of the integration is to populate the ON-AIR Pro™ system with Program Ratings information to better inform promotion/marketing decisions based upon presenting real world performance and ratings trends within ON-AIR Pro™.
Method | Trigger | Originated By | Data Source | Data Recipient |
File Based(XML, Excel, .tab, .csv…) | Scheduled / Manual | ON-AIR Pro™ Server /User | Program Scheduling System | ON-AIR Pro™ |
ODBC Query (SQL/Oracle) | Scheduled | ON-AIR Pro™ Server | Program Scheduling System | ON-AIR Pro™ |
Web Service (XML) | Scheduled | ON-AIR Pro™ Server | Program Scheduling System | ON-AIR Pro™ |
Traffic System Integration
1. Push ON-AIR Pro™ Promo Inventory into Traffic System
Description: The goal of the integration is to populate the traffic system with the promo inventory of produced, or expected to be produced, promos and air-able media elements from ON-AIR Pro™, which is managing the production of this inventory. This reduces duplicated data entry and helps On-Air Schedulers maintain focus upon more important decisions that are required for smooth network operations.
Method | Trigger | Originated By | Data Source | Data Recipient |
File Based(XML, Excel, .tab, .csv…) | Scheduled / Manual | ON-AIR Pro™ Server /User | ON-AIR Pro™ | Traffic System |
ODBC Push (SQL/Oracle) | Scheduled | ON-AIR Pro™ Server | ON-AIR Pro™ | Traffic System |
Web Service (XML) | Scheduled | ON-AIR Pro™ Server | ON-AIR Pro™ | Traffic System |
2. Import of Traffic “As-run” Air Log into ON-AIR Pro™
Description: The goal of the integration is to populate ON-AIR Pro™ with accurate air date information for the actual spots and media that were aired. This data is then used to provide accurate and “push of a button” Music Usage reporting for both music library publishers and music royalty management companies. This information may also be used by on-air promotions to identify issues with over-production of materials for air or operational problems meeting on-air requirements.
Method | Trigger | Originated By | Data Source | Data Recipient |
File Based(XML, Excel, .tab, .csv…) | Scheduled / Manual | ON-AIR Pro™ Server /User | Traffic System | ON-AIR Pro™ |
ODBC Query (SQL/Oracle) | Scheduled | ON-AIR Pro™ Server | Traffic System | ON-AIR Pro™ |
Web Service (XML) | Scheduled | ON-AIR Pro™ Server | Traffic System | ON-AIR Pro™ |
ODBC Insert (SQL/Oracle) | Scheduled | Traffic System | Traffic System | ON-AIR Pro™ |
Media/Digital Asset Management System Integration
1. Push ON-AIR Pro™ Promo Inventory into MAM System
Description: The goal of the integration is to populate the MAM system with the promo inventory of produced, or expected to be produced, promos from ON-AIR Pro™, which is managing the production of this inventory. This integration can also be expanded to provide links to proxy media for display via the ON-Spot™ plug-in.
Method | Trigger | Originated By | Data Source | Data Recipient |
File Based(XML, Excel, .tab, .csv…) | Scheduled / Manual | ON-AIR Pro™ Server /User | ON-AIR Pro™ | MAM System |
ODBC Push (SQL/Oracle) | Scheduled | ON-AIR Pro™ Server | ON-AIR Pro™ | MAM System |
Web Service (XML) | Scheduled | ON-AIR Pro™ Server | ON-AIR Pro™ | MAM System |
2. Updates of Media Asset Management systems metadata within ON-AIR Pro™
Description: The goal of the integration is to update ON-AIR Pro™ with accurate media information such as actual filenames, as produced, or the URL links to proxy media, or updates to reflect Approvals of spots.
Method | Trigger | Originated By | Data Source | Data Recipient |
File Based(XML, Excel, .tab, .csv…) | Scheduled / Manual | ON-AIR Pro™ Server /User | MAM System | ON-AIR Pro™ |
ODBC Query (SQL/Oracle) | Scheduled | ON-AIR Pro™ Server | MAM System | ON-AIR Pro™ |
Web Service (XML) | Scheduled | ON-AIR Pro™ Server | MAM System | ON-AIR Pro™ |
ODBC Insert (SQL/Oracle) | Scheduled | MAM System | MAM System | ON-AIR Pro™ |
On Screen Graphics (OSG) System Integration
1. Push ON-AIR Pro™ Promo Metadata into On Screen Graphics (QSG) System
Description: The goal of the integration is to populate the On Screen Graphics System with all relevant metadata to better automate the production of routine inventory such as “snipes”, lower thirds, and other new an emerging promotions elements that are produced with quick turnaround or using automated systems of real-time graphics rendering technology. This reduces duplicated data entry for Editorial/production staff as well as On-Air Schedulers, while reducing the opportunity for error before air.
Method | Trigger | Originated By | Data Source | Data Recipient |
File Based(XML, Excel, .tab, .csv…) | Scheduled / Manual | ON-AIR Pro™ Server /User | ON-AIR Pro™ | OSG System |
Disclaimer: All trademarks other than ON-AIR Pro™ and it’s plug-ins (which is owned by Thought Development Corp.), remain the property of their respective holders, and are used only to describe products commonly used within the industry. The use of other trademarks does not indicate any relationship, sponsorship or endorsement of Thought Development Corp. or its products, by the holders of said trademarks.