How to join Spotwatch and DB2 for iSeries (AS/400)

Discover how to join Spotwatch with DB2 for iSeries (AS/400) for integrated analysis.

WITH PIPES OR PIPES PROFESSIONAL
How to join Spotwatch and DB2 for iSeries (AS/400) with Pipes
WITH THE LOGICAL DATA WAREHOUSE
How to join Spotwatch and DB2 for iSeries (AS/400) with Logical Data Warehouse


About Spotwatch

Spotwatch is a technology and solution for TV tracking, TV triggering and TV data analysis as well as media research in real time from one system. For example, it allows you to automatically adjusts your AdWords keyword bidding after a TV spot in order to prolong the advertising effect.

About DB2 for iSeries (AS/400)

IBM DB2 is a relational database management system for enterprise-wide solutions developed by IBM. A relational database is a database in which all of the data is logically contained in tables. These databases are organized according to the relational model. In a relational database like IBM DB2, referential integrity ensures data integrity by enforcing rules with referential constraints, check constraints, and triggers.

What is Data Virtuality?

Data Virtuality enables companies to build an agile BI stack in 1 day. It connects to Spotwatch, DB2 for iSeries (AS/400) and more than 200 other databases and cloud services. All connected data sources can be directly queried with SQL and data can be moved into any analytical database. Customers of the Data Virtuality Logical Data Warehouse are digital businesses with the highest flexibility needs.

IMMEDIATE DATA ACCESS

Connect over 200+ databases, cloud services and files (XML, CSV, etc.) in minutes. Query data directly with your favourite business intelligence and analysis tools.

CENTRAL DATA MODEL

Build your single source of data truth and set uniform definitions for your data. Connect your business intelligence tools to Data Virtuality and make sure everyone in your organisation works with the right data.

ALL IN SQL

With Data Virtuality you can query all data sources with SQL regardless of the file format. NoSQL, CSV or XML File: We transform any connected data source in SQL.

REAL-TIME REPORTING

Data Virtuality controls the exchange of data between all databases, cloud services, and analysis tools to help everyone in your organization get the right information, in real-time if needed.