I Feel Like Alice Down a Rabbit’s Hole

Recently I used a data modeling tool called TOAD to reverse engineer a SQL application.     The basic idea is that you can take an application, load it into the tool and magically you can generate a report including a visual diagram showing the layout of the application (where data comes from, what it links to — that sort of thing).  This is really handy because normally it would take the original programmer “knowing” or days and days of searching through code to find the information.

In TOAD if you click on one of the tables in the diagram it takes you to a report showing you all the information you’d ever need to know (and some you could care less about).   Really cool.

Even cooler is the fact that using TOAD you can write in stuff you need and it will generate the SQL (structured query language) code for you — programming in other words.

The reason I feel a bit like Alice falling through the rabbit hole is because there are a ton of these tools out there.  I stumbled upon TOAD (which is owned by Dell Computers), but there are tons of these tools.  Some are in the thousands of dollars and support big companies with big staffs.  Some are free or pretty cheap.  You can get a free, albeit limited, version of TOAD.

Computer departments use these to help in development, but they can be really valuable business tools — if you have the right information that isn’t “all technical in your face” — and some of the tools can generate business type reports which will let management make intelligent decisions based on the information they glean from these reports.

My confusion of the moment is finding the right tool for business users — one that creates a web site that lets them move around the information they need without being overwhelmed.   I guess I better get back to my analysis!

Advertisements

About Sandra Eisenberg

Dynamic pragmatic marketing and sales executive whose biggest asset is converting technology to real corporate value -- for a variety of industries including health care providers (Adventist Health System Sunbelt), Teradata (Data Warehousing), RWD Technologies (quality improvement and professional services), Siemens and AT&T (telecom). Sandra brings twenty years of experience in sales, marketing and IT management. Her career spans entrepreneurial firms (E5 Marketing) and senior positions in sales, sales management (direct and indirect), marketing, channel development and product management at Bell Labs and NCR Teradata. A few career highlights: • Total product lifecycle management (PLM) using ISO 9001 and other quality methodologies. Sunset aging product lines and developed a migration path to a new, open standards platforms at Avaya, NCR and Bell Labs. • 1st woman to win the AT&T and NCR Teradata national sales awards -- top sales manager and sales rep at AT&T, NCR Teradata and Avaya • Delivered profitable marketing campaigns in the area of CRM, Business intelligence, contact centers and other high tech areas • Run call centers, sold call centers and been in product management of call centers (Avaya, AT&T and NCR) • Director of CRM Strategic Planning and Alliances at Avaya and NCR Teradata • Senior Manager of Product Management Bell Labs (business intelligence, data warehousing and CRM) Most recently Sandra managed the Central Florida territory for Siemens' telephony division. Siemens is selling this division soon and their loss can be your gain.

Posted on November 12, 2013, in Technology. Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: