Integration


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.