• Data Juggler connects to your Oracle, Microsoft Access, or SQL Server database
• Easily link to important tables in your RMS quickly
• Move data from one server database to another, from a server to Excel or Access, or from Access or any data up to your server database again

Automatically extract data from a records management system and then import it into an MS Access database using a standardized structure shared by hundreds of law enforcement agencies.

• Schedule Data Juggler to automatically extract data during off-peak hours
• Automatically update crime analysis databases so analysts can work with data in real time
• Data Juggler uses a read-only connection so your RMS data remains safe and secure
• Data Juggler pulls data so the end user can use it more readily in desktop applications such as ArcGIS, ATAC, and Excel

Data Juggler maps and translates coded data into literal values so analysts can quickly start analyzing data.

• Time and date conversion for standardized temporal analysis
• Build SQL statements using a point and click interface

Translate the codes that Data Juggler downloads from your RMS into the variables that you want to work with. Classify values in a way that will allow you to complete analysis more efficiently.

• Easy to use graphical user interface
• Create and store data translation and data mapping routines for future use through an easy to use data scheduler

• Combine multiple police narratives from separate records into a single report
• Combine individual lines of a police report into one memo field for easy reading and analysis
• Add a sequence number to any table based on data stored in any variable
• Translate text stored in MS Word documents into useable and searchable database fields
• Remove extra spaces from your data
• Concatenate and merge data from multiple field