RosettaEIP: data management for the transport industry
A secure cloud Enterprise Integration Platform that captures and ingests multiple data sources into an SQL database for interrogation, segmentation and export into business and marketing systems.
RosettaEIP’s Key Features
Seamless integration of unrelated data sources in multiple formats
Integration with external sFTP, REST & SOAP APIs and other systems for data input/output
Optimised for use with Email Service Providers (ESPs)
Pre-built marketing segmentation for ESPs
Pre-built support for Rail industry data sources
RosettaEIP Key Points
RosettaEIP Key Points
Ready‑to‑Use
Once it is set up RosettaEIP does not require a high level of technical skill to use or maintain. You can add new data sources yourself using the RosettaEIP drag and drop User Interface.
Single Unified Customer View
Disparate data can be organised, correlatedand segmented and visualised to deliver grouped and individual data profiles. You get a 360-degree view because RosettaEIP holds all of the data you have on your customers and ‘meta’ data that contextualises their behaviour or they interact with..
Accessible Data
Data contained within Rosetta can be used by 3rd party systems.
RosettaEIP Feature Set
Full file transfer capabilities
We offer both client and server functionality on SFTP to deliver push and pull services
Integrating unrelated data sources
Using a shared marker, such as an email address, as a common index we are able to match customers across multiple unrelated sources
Data warehouse processing
Data formats change over time but RosettaEIP adapts the schema ingestion to cope with these changes
Redundancy and disaster tolerance
RosettaEIP was designed to be disaster tolerant from the start, all processes are protected against failure, meaning data is never lost, processing always works, and you know what is happening with your data
Relational & Object Databases
RosettaEIP can cope with tables that relate to each other and data sources that are stand alone.
Multiple data sources
We can ingest any number of different data sources, each data source contains multiple tables
Named segmentation containers
Grouping and dividing varied data sources into intuitive marketing query schema, reducing data storage requirements in ESPs
Multiple Schema validation
The schema of ingested data is validated using multiple automated approaches. Easy to expand validation means we can reduce dirty data issues.
Multiple processing schedules
Multiple schedules for both SFTP processes, data ingestion and Segmentation Container Exporting for Campaign Management Tools
Support for rail industry data
RosettaEIP already deals with rail industry web ticketing extract/data warehouse/seasons/smartcard plus Goldstar, marketing websites and others
Daily statistics and analytics
Every activity is logged. RosettaEIP performs daily analysis and auditing of its own performance to comply with ISO27001
Power BI integration
Unrestricted access to your marketing data through the PowerBI Interface. Feature rich user administration and monitoring interfaceMicrosoft
Full Azure cloud platform support
Full support of Azure features including Infrastructure as Code Deployment and continuous development / continuous integration
Integration with industry leading ESPs
RosettaEIP outputs and integrates seamlessly with ESP customer schemas, programs and segments. RosettaEIPs integrated data stores can enhance customer data by deriving LTV, CPA and customer profiling