The Daily Data Extractor (DDX) is an installable software application. 

Its purpose is to securely transfer data from a ticketing system database to the Purple Seven Server over an internet connection. 

• The DDX operates on a regular basis determined by a Windows Service created on the same machine on which the DDX is installed.  
• It is required that the application is opened using Administrative privileges
• On activation, the DDX contacts the Purple Seven Server to receive SQL scripts to run against the ticketing database.  
• The DDX then transmits the resultant data back to Purple Seven’s server. 
• The DDX can also be manually initiated through the application control panel. 

The DDX is a simple Windows Forms application developed in VB.NET.  It is designed to be installed directly on a server or PC that:

1. can connect via connection string to the SQL Server database where the ticketing data is stored and,
2. has access to the internet. 

The DDX uses the standard port 443 for its SSL / TLS tunnelling. Usually no alterations or special ports should need to be opened. 

The DDX For SQL is compatible with the following ticketing systems: 

• Patron Base
• ENTA
• Tessitura
• Theatre Manager (Self hosted) 

SUPPORTED OPERATING SYSTEMS 

• Microsoft Windows 10
• Microsoft Server 2012 or later

PROCESSOR 

• Client (a computer not working in a server capacity): 90-megahertz (MHz) Intel Pentium- class processor or an AMD Opteron, AMD Athlon64 or AMD Athlon XP processor or better.
• Server (a computer working in a server capacity): 133-MHz Intel Pentium-class processor or an AMD Opteron, AMD Athlon64 or AMD Athlon XP processor or better. 

SOFTWARE REQUIREMENTS 

• Microsoft Internet Explorer 5.01 or later
• .NET Framework 4.5

HARD DRIVE 

• 110 MB of hard disk space required, 40 MB additional hard disk space required for installation (150 MB total)  

The data is sent via a TLS /  SSL tunnel to a web service hosted on our secure.purpleseven.com domain, which is secured by a Sectigo certificate providing SHA256 bit encryption. 

If you need to configure a firewall or whitelist access to our servers, then allow outbound connections to 78.129.176.121 on port 443.

The resources used by the DDX are dependent on a number of factors (such as PC specification, ticketing system, network and internet speed) which cannot be easily predicted and organisations of different sizes will have different resources available to them.   

For example, a ticketing consortium may well have a fast connection to the internet which will reduce the time it takes to transfer the data compared to a mid-sized organisation which may have an ordinary broadband connection.

The SQL scripts are normally authorised by each ticketing system supplier and you should contact your supplier to ensure that the scripts for your system have been authorised by them.  Scripts are written to use indexed fields to filter the data. This increases speed and reduces processor overhead.   Custom scripts can be developed on request (usually at a charge).  The following details the average extract and upload time: 

The DDX will extract the fields as defined in the SQL scripts executed against your database.   

Typically the DDX will extract the following types of data: (As the exact fields change for each Booking System and on occasion we are asked to modify the scripts on a per client basis the following should be used for guidance only). 

• Customers records (name and contact details) 
• Ticket Records (seat location, price, discounts and price types) 
• Performance records (date and time and capacity of performance) 
• Event / Run records (name and location of run) 
• Customer and event categorisation records (e.g. Artforms / interest codes) 
• Memberships records (membership type, start / end dates, price) 
• Donation summaries (who, how much, when)
• Subscription Data (who, which package, how much etc)

The above is a summary of types of data we collect.  If you would like the exact fields you can either:

1. view the scripts that will be run against your system from within the DDX application or;
2. Contact Purple Seven.

To contact Purple Seven about the DDX: 

Email: [email protected]