User:Andi Database Productivity Tool/sandbox

This is the user sandbox of Andi Database Productivity Tool. A user sandbox is a subpage of the user's user page. It serves as a testing spot and page development space for the user and is not an encyclopedia article. Create or edit your own sandbox here.

Other sandboxes: Main sandbox | Template sandbox

Finished writing a draft article? Are you ready to request review of it by an experienced editor for possible inclusion in Wikipedia? Submit your draft for review!

Andi is a database productivity tool with features that allow users to access their data, regardless of their SQL knowledge. Andi is used by System Testers, Business Analysts, Developers, Production Support, Performance Testers, Database Administrators or general users needing access to their data. Andi provides SQL access to relational and non-relational databases using a JDBC Driver. Andi is designed for selecting data, sorting, filtering, and analyzing result sets containing hundreds of thousands, to millions of rows of data limited only by the physical memory.

Supported databases and environments

Andi supports access to relational and non-relational databases using JDBC drivers. Progress Software provides enhanced, high speed JDBC drivers to access a broad range of databases.

BIG DATA

Apache Cassandra
Apache Hadoop Hive
Cloudera CDH Hive
Hortonworks Hive
Pivotal HD Hive
Amazon EMR Hive
MapR Hive
Cloudera Impala
MongoDB
SAP Sybase IQ
Pivotal Geenplum
Teradata
Amazon Redshift
Spark SQL
SAP HANA

RELATIONAL

Oracle Database
IBM DB2
IBM Informix
Microsoft SQL Server
MySQL
SAP Sybase
PostgreSQL
Pervasive SQL (Btrieve)
Progress® OpenEdge®
Progress® Rollbase®
Clipper
Dbase
Foxpro

SaaS/Cloud

Data Sources Using Salesforce1 Lighting Connect
Salesforce.com
Database.com
FinancialForce
Force.com Applications
Hubspot
Marketo
Microsoft Dynamics CRM
Microsoft SQL Azure
Oracle Eloqua
Oracle Service Cloud
ServiceMAX
Veeva CRM

Supported Operating Systems

Andi runs on all Windows 32 bit and 64 bit platforms.

History

Kerry O'Brien, a Software Developer, started the design process for Andi in 2001 out of frustration with the currently available tools. Having completed development of a large batch job, started integration testing. Unfortunately, the batch job modified a large tree of related tables so verifying the data meant running a stream of SQL statements, one at a time. The process involved executing a SQL statement, grab a key value and use it to select a child table and so forth. Unfortunately, by the time he executed the nth statement, the question that came to mind is "did I use the right key value". At that point, there is no other choice but to start over. After two frustrating days of failed testing, Kerry went home and created a prototype version of the Andi View Organizer and completed his testing the next day, in fifteen minutes.

References

Official Andi site

External Links

Official Andi User Community