Software Information |
|
Database Guru James F. Koopmann Reviews DBxtra Reporting and Query Tool
DBxtra is a powerful query and reporting tool that hides many of the complexity and technical expertise required for creating connections to disperse data sources, building queries, designing reports, and delivery information throughout an enterprise or to your customer base. With the ability to connect to multiple databases or data sources at the same time, DBxtra allows for cross platform data aggregation and the ability to answer questions that would typically take IT time to migrate data into a single reporting database. Through powerful query and filtering mechanisms users have the ability to browse and achieve fine grained retrieval of data to answer detailed business questions. DBxtra uses a project level approach and Explorer type tree structure to categorize database and DBxtra objects that facilitates the production queries and reports. This explorer tree structure drastically improves the reusability of objects, speed in access to information, and reduces the man-hours required to design and produce subsequent reports. The production of reports can be produced in a variety of formats including HTML, Microsoft Excel, CSV, XML, or PDF with the option to be merged into personalized E-mails. Also available is a visual report designer where your choice of formatting options can be employed to produce just the right look for your report. DBxtra comes very close to their goal of "no programming or database knowledge required". All the while creating a new breed of power end-users. Getting familiar with DBxtra How a product "feels" is always a big concern when delivering a product that will actually improve the productivity of end users and reduce the burden on IT. I personally like to try a product without reading the documentation. While I have years of experience as a DBA, analyst, developer, and data modeler I honestly try to block all that information out of my mind to "feel" what it would be like to operate under limited expectations. The only mind-block I needed to get over was double clicking on objects to activate their usage. Honestly if I would have read the help on the top and bottom of the screens this could have been eliminated. DBxtra has a very nice step by step approach, almost like an Install Shield approach, that drives you through creation of queries and reports. Once getting use to clicking through this stepwise approach I was building queries and reports quicker than I could think of examples to model. All of which I didn't need to know anything about data models other than identification of which database my tables where. The only database modeling concepts that end users need to understand are tables, columns, joins, filters, sorting, and aggregate functions. All of which are very teachable and most end users understand a large subset of these concepts. DBxtra comes with a load of documentation including tutorials and video streams. All of which are very helpful and will walk you through the major features of this product. I watched all the tutorial videos and picked up some valuable hints on how to use the product. It is very unusual for vendors to go to this length to educate their end users. I read this as a true commitment on the vendor's side to make sure you are able to use the product and it not to become shelf-ware. Very admirable! Another training aid is the shipment of a sample data source, with queries, reports, and schedules. This allows you to quickly dive into the product and get a good feel for the product without ever touching your data sources. Of course you will eventually want to produce some queries and reports against your databases as there is nothing better for determining the effectiveness and usefulness than seeing your own data. Corporate Profile Problems Solved Can your end users get to the data they need? How often do they need to wait for a developer to provide assistance in the extraction of vital information? It does not matter if you are part of the executive team or an end user. Often times when you want to get to information from a database or restricted system you need to request work to be done on your behalf. You are at the mercy of your IT staff and in particular developers, data analysts, data administrators. With DBxtra end users are liberated from the ever-increasing queue that is experienced every time they need IT staff to produce reports or extract data. DBxtra allows users to access multiple data sources in disperse database systems and pull information from these sources in a systematic pint and click fashion. The ease in which it is to produce reports, and more importantly alter reports when business rules change, will have a drastic impact and increased productivity for your end users while also reducing the burden on IT. Since DBxtra can connect to most any database or data source, you can provide a tool the is truly cross-platform independent. This actually reduces the toolset required, provides a single access point to data, and reduces training requirements. Who should use it Anyone who wants to produce quality reports or just query data in an ad hoc manor can benefit from DBxtra. With a powerful toolset DBxtra assists end users as well as the IT staff. in the categorization and processes around defining where information is, how it is retrieved, and who needs the information. Developers, analysts, and DBAs will benefit from this tool as they interrogate data across multiple systems. Working with DBxtra Below is presented with my experiences working with the DBxtra product. While the demos and tutorials take you through many of the feature set it is highly recommended you use the product to see how it works in your environment. When you first start up DBxtra you are prompted to accept the license agreement and then need to create a DBxtra database for housing reports. Within the directory you supply to house the DBxtra database a new directory will be created along with a .mdb (Microsoft database) file. While using DBxtra additional directories and files may be created in this directory. I was then prompted to create an administrator password for the Microsoft database and then required to login. These few setup procedures and only need to be done once and were not time intensive. All work is done through projects and you will need to create one before producing any report or querying any data. After you have defined a project you can define the connections to databases and add database objects to use within the newly created project. I was very happy to experience an error free mechanism for creating connections to Oracle, SQL Server, and Microsoft Excel. After defining a project and adding database objects to it you are then put into the Data Explorer. The Data Explorer is the heart of the organizational system for DBxtra where you access and place objects such as database objects, reports, and queries. Data Explorer is a tree structure that, as you get familiar with the toolset, allows for easy retrieval and quick access to previously defined objects. At this point it is a nice place to click the "Show Data" option and prove to yourself the ease at which DBxtra can extract information from different data sources. You may also at this point get familiar with one of the more powerful filtering mechanism through the "Show field values" option. With this feature you can extract values for an object that can be used in equality matches on columns. Just click the "Show field values" box, select a field for the equality operation, and magically you can use the drop down list and assign a value for the equality. Powerful and very user-friendly. Now just hit the "Show Data" button to return the filtered result set. Query Builder allows for the definition and saving of queries within the Data Explorer tree structure. Defining a query is accomplished through naming the query, selecting data sources, selecting objects for the query, building relationship and filters where necessary, and then possibly sorting the data. As you use DBxtra you will soon notice that tabs across the top of the screens present the order in which you should follow. It is an easy approach to define the object or procedure you are building and very intuitive at the same time. I personally like things that have a definite flow and DBxtra provides that for me. Building reports where again just as easy. Just follow the script presented in the tabs on the screen. Reports have the ability to be exported to text, XML, PDF, Microsoft Excel, and HTML. A unique feature of the DBxtra is to export the report to a Microsoft Excel pivot table and chart where the Excel spreadsheet is pre-built with a constant connection to the data sources. Whenever the database is updated and the user of the Excel report presses the refresh button the data in the spreadsheet is also updated. Other options that I did not try were the E-mailing and scheduling of reports. I did watch the demos and looked at the screens. Again the common thread of the step by step tabular approach existed in these options and thus presented no surprises. An interesting feature was the ability to write a simple e-mail merge operation that allows for the sending of a report in an email while tailoring the e-mail on merge fields for personalization. Hardware / Software Requirements ? Processor 600Mhz Download and Installation You can get a free 15 day trial off DBxta's web site at http://www.DBxtra.com/DBxtra/registro.asp If you would like to keep in touch with DBxtra and receive some free support and other valuable information about using the product while you are in trial then you should give them your name. But name registration is not required for the free trial. As an interesting feature to the download, if you decide to not purchase by the end of the trial the product deprecates itself from the Professional Edition into the Free Edition. I have never seen this before and like the concept because you don't need to worry about removing the product. Plus at the end of the trial you still have a product that is usable. The download and installation went very swiftly with a clean and very few clicks to install the software. License There are three distinct products for DBxtra that include a standard, professional, and report viewer. After a trial period of 15 days the product deprecates to a free version. Pricing is currently available for a single concurrent user and you are given price breaks as the number of concurrent users increase. This ranges from around 25%-33% depending on how many licenses you buy. Also to note is that the license is for concurrent users and not for installed copies of DBxtra. This means that you can install everywhere and use where you like. The pricing is very reasonable in my opinion and depending on the number of licenses you purchase you can put the power of data extraction into end users for less than $150 USD. Support is free as are upgrades for year 2005. Rudolf Vanek See more information: http://www.dbxtra.com
MORE RESOURCES: Check Point Software Reports Fourth Quarter and 2024 Full Year Results Check Point Software DeepSeek AI Is 'Good News' For Enterprise Software, Says SAP CEO Investor's Business Daily Advisory details ransomware attacks on SimpleHelp remote access software American Hospital Association Honda issues recall over software glitch. Which vehicles are affected Lansing State Journal Guide to Legal Technology Software Bloomberg Law Exclusive: Apex Custom Software hacked, threat actors threaten to leak the software DataBreaches.net Honda recalls 295K vehicles for software issue KOBI-TV NBC5 / KOTI-TV NBC2 Clear-Com Unveils EHX v14 Software Update Sports Video Group Walmart has H&R Block tax software on sale for up to $16 off to save on filing your 2024 taxes NJ.com JONAS CLUB SOFTWARE UNVEILS INNOVATIONS & THE JONAS OPEN VIRTUAL GOLF TOURNAMENT AT THE 2025 CMAA CONFERENCE The Golf Wire Nearly 300,000 Honda and Acura Vehicles Recalled Over Faulty Software, Engine Stall Risks AboutLawsuits.com Managing the Risks of China’s Access to U.S. Data and Control of Software and Connected Technology Carnegie Endowment for International Peace Serco Expanding U.S. Business With Acquisition Of Northrop Grumman’s Training And Software Unit Defense Daily Network Honda recalls 295,000 vehicles due to software error that could cause engine to lose power USA TODAY Atlassian Earnings Beat. Software Maker's Revenue Guidance Above Views. Investor's Business Daily North Korean Lazarus hackers launch large-scale cyberattack by cloning open source software TechRadar Checkpoint Software (CHKP) PT Raised to $220 at Stifel StreetInsider.com QBS Software picks up Prianto ComputerWeekly.com SLK Software's promoters look to sell majority stake The Economic Times Checkpoint Software (CHKP) PT Raised to $220 at Mizuho StreetInsider.com PE Weekly: Deloitte Acquires ERP Software; Food and Beverage Deals Return Middle Market Growth Website Builder Software Market is projected to grow at USD 3.9 billion by 2032, CAGR with 7.9% EIN News KCS showcases its latest software at ARA Show International Rental News Cathie Wood Says Software Is the Next Big AI Opportunity -- 2 Ark ETFs You'll Want to Buy if She's Right The Motley Fool IBM Stock Pops On Earnings Beat, Software Growth, Free Cash Flow Outlook - Investor's Business Daily IBM Stock Pops On Earnings Beat, Software Growth, Free Cash Flow Outlook Investor's Business Daily SAP extends support deadline for getting off legacy software – in very special circumstances The Register Checkpoint Software (CHKP) PT Raised to $240 at Raymond James StreetInsider.com Checkpoint Software (CHKP) PT Raised to $220 at Cantor Fitzgerald StreetInsider.com IBM Is Seeing Growth in Software and AI Morningstar Appraisals for software engineers: Microsoft and Amazon are using performance reviews to decide who gets s The Economic Times Orchard Software Named Top LIS Vendor by 2025 Black Book Market Research for Seventh Consecutive Year PR Newswire Securing the Software Supply Chain: A 2035 Blueprint The New Stack American Honda Recalls 295,000 Vehicles in the U.S. to Update Fuel Injection Software Honda Newsroom Hg looks to raise $12bn for large-cap software bets Private Equity International Earthquake Alert Software Market May See a Big Move | Major Giants LastQuake,QuakeWatch,GEOFON openPR The toll Trump 2.0 could take on LatAm’s software, IT services exports BNamericas English Check Point Software Technology (CHKP) Tops Q4 EPS by 5c StreetInsider.com Check Point Software shares edge lower after Q4 results Investing.com Drone company's software will no longer stop flights over wildfires, other no-fly zones NBC San Diego Google open-sources the Pebble smartwatch’s software, and its creator is making a new model Engadget Startups to Watch 2025: VedaPointe's software automates workflow to improve health care The Business Journals HeartBeam submits 510(k) application to FDA for ECG software Medical Device Network Former Cruise engineers launch AI-powered design software startup Hestus The Business Journals Plus expands from self-driving to software-defined ADAS Automotive World Accelerating software that helps the helpers BetaKit - Canadian Startup News How a Free Software Strategy Catapulted DeepSeek to AI Stardom The Wall Street Journal |
RELATED ARTICLES
Microsoft CRM Modification - Overview for IT Specialist Microsoft CRM is now on the scene and it is increasing its market share, due to the Microsoft Business Solutions muscles and marketing strategy. It is tightly integrated with other Microsoft Business Solutions products such as Microsoft Great Plains, Solomon, Navision. Microsoft Great Plains: Annual Enhancement Program - How To Be Re-Enrolled Microsoft Business Solutions Great Plains is mid and even corporate market ERP and as being relatively complex and difficult to do self-support in-house, Microsoft Business Solutions requires you first to have so-called VAR of record, or your MBS partner and second - pay annual enhancement program, which is typically 16% of you software price list. Enhancement program allows you to get new version of the product as well as purchase and add new modules you might need. Microsoft CRM Implementation & Remote Support We would like to give you pluses and minuses of Microsoft CRM.Web and MS Outlook based client - this means that you don't need additional installations or training - everyone is using Outlook if you are on Windows XP/2000/2003SQL Server database - just to mentionIntegration with Microsoft Exchange 2003/2000 - this means that replies to CRM originated emails will be captured and store in CRM as activities for the Contact, Account or Lead. Software Development in 2005 - Back to the Future 2005 - Back to the Future.What does the future hold? A big question and initially the answer is anything and everything. Groupware: Avoid the Ad Hoc Shuffle GroupwareEfforts are continually made to manage the unavoidable ad hoc business process, but ad hoc processes do not necessarily mean a pile of messy, shuffled documents, at least not anymore. Groupware is software which tracks and manages the ad hoc business collaboration. Is Software Tester a Most Infamous Person in a Software Project Team? The fact that a software tester is a most infamous person in a software project team has some grounds underneath it. This is because a software tester usually speaks of the bugs in the developer's code. OEComplete - A Personal Information Manager OEComplete is a utility for managing the personal information of the user. It is designed to be flexible and affordable even for the home user. Manufacturing Solutions for Microsoft Great Plains - Overview for Consultant Microsoft Business Solutions Great Plains has full-featured manufacturing set of modules. In this small article we would like to give you highlights on what kinds of light customization you could deploy, before jumping into Microsoft Great Plains Manufacturing realm. Industry Experts Answer the One Million-dollar Question - Why Genie Backup Manager? Many reasons made GBM a unanimous choice for experts, one of them is the fact that with the set of features it offers, it's definitely the easiest to use."Genie Backup Manager Professional has a clear, simple interface which lets you manage the application without problems and in just a few minutes," the UK's Personal Computer World (PCW) stated in its Feb 2005 review of GBM, in which it selected the application for its Highly Recommended award. Microsoft Great Plains Project Accounting - Overview For IT Director/Controller Microsoft Business Solutions is now in process of creating so called Microsoft Suites: Microsoft Financials, Microsoft Logistics, Microsoft Manufacturing, Microsoft Professional Services - this last one will be based on Solomon Project module. The long story of Great Plains Software Project Accounting - it was originally created by MatchData, which was bought by Great Plains in late 1990-th and renamed into Great Plains Project Accounting. Call Alert Notifications - Free Answering Machine Software for PCs If you're online using a dialup Internet connection, you'll probably want to download one of the free call alert software applications like Callwave or AOL Call Alert that can answer, record, and forward incoming calls to your home, office or cell phone. In fact, if you run a small business, Call Wave also offers a dedicated business fax service too. Adware, What Is It? Adware is a type of Spyware program that displays some kind of banner advertising as you're surfing the Internet. Most of the time, you will pick these programs up if you download other programs such as freeware, shareware, and file-sharing programs. 3 Reasons Why Medical Billing Software is Leading the Way Since technology changes so quickly, it is hard to begin by saying "in the old days . . Microsoft Great Plains & CRM in Transportation & Logistics - Overview Microsoft Business Solutions Great Plains and MS CRM (client relation management system) are very popular in various industries and market niches. In previous article we described Microsoft Great Plains implementation for transportation & logistics company. Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free? Heard about the Quark "killer"?Adobe InDesign CS2. Will it really "kill" Quark? Adobe has been saying "it will" for the last six years or so, but it hasn't happened. Corporate ERP: Standard vs. Rich functionality - Microsoft Great Plains Traditionally we were considering functionally rich systems, such as SAP, Oracle Financials, PeopleSoft, JDEdwards as the fit for large publicly traded corporation. There might be multiple opinions for the future corporate ERP/MRP systems. Recent Studies Show that 9 out of 10 PCs Are Infected with Spyware Spyware and malware are large problems for Internet users today and can be both annoying and a real threat to you and your computer. There exist a number of different spy and malware of which some are relatively friendly and only spies on your surfing habits, while others like the Trojans can be used to corrupt your hard drive or steal your usernames and passwords. Linux Vs. Windows This article will not attempt to advocate the use of Linux over Windows or vice versa. I will try to present the differences and similarities between Linux and Windows in a fair manner. What is Spyware? Are You Being Watched? Find out why Spyware Removal from computers is important and how adware infestations affect your computer, your privacy and your family.Internet users worldwide spend several hours to several days each week browsing or searching the net. Software Piracy SOFTWARE PIRACY We regularly hear reports about the cost to the software industry of software piracy, but are the claims to be taken at face value? Statistics are notoriously biased towards what the author is trying to say. Types of Software: There are three basic types of software, although these do have their own subsections, as will be discussed later: 1. |
home | site map |
© 2006 |