JMP® Data Server for Multi-User Organization with Diverse Data Source
Neal Verzwyvelt, Atmel Corporation
JMP® has proven its ability to add value to an organization though powerful data analysis capabilities. A problem faced by many organizations is that of getting data into JMP® for analysis. Even with a rich set of import utilities, users often do not know where to find a given data set or which import method is best suited to the particular data source. In addition, the native ODBC (Open Database Connectivity) interface in JMP®, if used to access databases, requires that each potential user’s PC have the necessary ODBC configuration setup and maintained, potentially creating a not insignificant workload for an organization’s User Services department. This had been the case at Atmel Corporation, where data required for maximizing engineer productivity was spread across Several RDBMS Systems (Oracle®, PostgreSQL, SQL Server®) as well as flat files. By using JMP® JSL, the Apache Tomcat Servlet Container, and Java programming language, a simple system of queries has been deployed that allow for flexible and fast data import into JMP®.