AbstractUtilizing Open Access Technology to Integrate SAS and Esri Applications Track: Business, Banking, and Insurance Author(s): William A. Ivey SAS Institute and Esri have many common customers that utilize each company's software in loosely integrated applications and solutions. These applications typically rely on Esri software for mapping and spatial analysis and SAS software to provide data manipulation and statistical analysis. This 'loose' level of integration typically involves the import/export of data from/to proprietary formats using a variety of non-standard processes. This type of integration has limited the potential and scope of use of these combined applications. Beginning with SAS Version 8 however, open access to SAS compute services and data sources are being made available. SAS Integration Technologies is a new product that gives client applications access to a wide range of features that are part of the SAS system both on the desktop and over the web. OLE DB consumers will enable SAS users to directly create and manipulate external DBMS tables and OLE DB providers will deliver SAS data sets to consumers. Coupled with the fine granularity of the Component Object Model (COM) objects available in ArcInfo 8, the Java APIs available with ArcIMS, and the geodatabase model in ArcInfo 8, a wide range of integrated applications can now be developed. This paper will discuss the tools available with SAS Integration Technologies and explore integrated applications that are possible with the latest software from SAS and Esri. William A. Ivey SAS Institute, Inc. SAS Campus Drive Cary, NC 27513 USA Phone: 919/531-6289 Fax: 919/677-4444 E-mail: William.Ivey@sas.com |