![]() ![]() This EarthChart plots recent Entrance visitor IP locations found using GeoLite. |
| News ANALYZING WEB SERVER LOGS In the first in a series of application notes on mining web server log data, we'll you how to use the MaxMind GeoLite or GeoIP datasets with Entrance to find out where your web site visitors are coming from. Click here for more. BI 2.0 We had a nice conversation with Michael Pittaro of SnapLogic at the MySQL Conference and the result was an EntranceExtension demonstrating that we can connect to their "Pipelines". The synergies, potentially, are huge. Later Mike wrote: Tod Landis was showing Entrance, a GPL licensed data browser, and Nate Williams of Kirix was showing Strata. Both of these tools are ‘data browsers’, but I view them as the beginning of a new generation of data access tools. They go beyond the basic query tool, and are moving into the realm of data display, visualization and analytics. At the same time, they are not traditional ‘report writers.’ Chris Marino writes about how he sees the this new product category in "BI 2.0 is here...". PLOT DATA FROM ANY JDBC DATABASE In Version 1.2.74 the command line utility includes an experimental option for specifying a JDBC driver: -d (jdbc driver class) It is not well tested yet, but should work... and it means you can use the Entrance SQL extensions to plot data from any JDBC database! WRITING EXTENSIONS IN APPLESCRIPT On a Mac, you can embed AppleScript in EntranceExtensions This note shows you how, and includes an example that connects Entrance to Google Earth. |
Buy Entrance for $39.95 or
Try for Free ($49.95 after May 31, 2008) Release 1.2.75 Windows Version (requires JRE 1.5 or greater) 1.7 MB download license installation Macintosh Version (for Leopard with JRE 1.6) 1.8 MB download license installation If you are running Leopard on a recently purchased Intel Mac, we recommend you download Apple' s JRE 1.6 upgrade and use this version. Macintosh Version (for Leopard or Tiger with JRE 1.5) 1.8 MB download license installation Linux Version (requires JRE 1.5 or greater) 1.7MB download license installation (If you purchased an earlier version of the IDE or we gave you one for helping, your serial number will continue to work with this upgrade) WHAT IS THE DIFFERENCE BETWEEN OUR IDE AND COMMUNITY VERSIONS? Our IDE version is built upon Entrance Community, and includes all community features. The Macintosh and Windows releases are specially tuned for their platforms. For example, SQL files can be dragged to the Entrance dock icon in the Macintosh version and they will open. The IDE editor supports syntax highlighting as well as these additional feautres: Undo, Redo, Paste from clipboard ring, Find, Find in path, Replace, and Go to line. "Find in path..." is something new for Entrance version 1.2.74. It does a quick search through the SQL files in your Entrance folders, searching for a match with the string you specify. For example, if you are about to draw a bar chart, and you have downloaded the charts.zip examples, you can quickly find a script to use as a starting point by searching for "barchart". |
Features Database browser (and the Match Box) SQL Editor Charts Statistics Data exchange Crosstabs Java Extensions Documentation Install Connect to a server View a table Make a chart Run queries Spreadsheets Import and export Explore data PLOT REPORT charts.zip NEW! Support The support page FAQ About us Entrance Community Version Release 1.2.75 For all platforms (with JRE 1.5 or greater) Read the Community Version (GPL v.2) license Download the Entrance Community Version Download the Entrance Community Sources |
| dbEntrance Software PO Box 2383 Boulder Creek CA 95006 831 338 6967 Copyright (c) 2007, 2008 dbEntrance Software. All Rights Reserved. MySQL is a registered trademark of MySQL AB in the United States, the European Union and other countries. Windows is a trademark of Microsoft Corporation. Macintosh is a trademark of Apple Computer, Inc. Java and the Java Coffee Cup Logo are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries. Solaris is a trademark of Sun Microsystems, Inc. |