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: 2024.14 Official Tesla Release Notes - Software Updates Not a Tesla App Software Firm Zuora Explores Options, Including Sale Yahoo Finance Hartselle Police, software company team up to support first responders’ mental health WHNT News 19 Viavi joins OpenAirInterface Software Alliance RCR Wireless News Hyundai and Kia owners urged to get software update to prevent thefts from ‘Kia Boys’ Eyewitness News 3 20 Top Software Companies in Gurgaon Built In The IRS's new tax software: Rave reviews, but low turnout The Washington Post Will Constellation Software Announce a Stock Split? 24/7 Wall St. Amsterdam's Rodeo Software rocked by allegations of fraud; major backer PSG Equity seizes €67M from founder Silicon Canals NAB 2024: Spectra Logic Introduces LumOS Library Management Software with Two New Libraries Sports Video Group Wabtec Secures Systems and Software Deal with ARTC to Support the Interoperability of Australia's National Rail ... Yahoo Finance F-35 JPO and Lockheed Martin agreement on FIAB software - Airforce Technology Airforce Technology H&R Block 'desktop software' e-filing tax-deadline issue fixed Monday afternoon KSHB 41 Kansas City News Risk analytics software: should your RIA firm have one? InvestmentNews Absolute Software Is Now Absolute Security Business Wire Ableton Live 12 music production software review Jazzwise magazine Royal Navy Selects SEA for Sonar Software Development The Defense Post Arm Stock Eyes This Segment As Software Will Become 'Survival' For Automakers - Video - IBD Investor's Business Daily Alaska Airlines briefly grounds all planes to address weight-and-balance software issue Must Read Alaska Army has burned the software development bridges behind them Federal News Network 7 Top-Rated Affordable CRM Software Software Advice ELFF's Economic Outlook Update Forecasts 2.2% Expansion in Equipment and Software Investment, 2.3% GDP Growth Monitor Daily Hstoday Open Source Groups Say More Software Projects May Have Been Targeted for Sabotage - HS Today HSToday "We've shifted the responsibility of extracting relevant context for software engineering tasks from developers to the AI ... Windows Central Software-based motor control 'boosts efficiency by up to 3%' - Drives and Controls Magazine Drives & Controls Outsight recognised for spatial AI software Airports International Magazine What Software Engineers Need to Know About AI Jobs IEEE Spectrum Are American Software, Inc.'s (NASDAQ:AMSW.A) Mixed Financials The Reason For Its Gloomy Performance on The Stock Market? Simply Wall St Zoloz enters the war on deepfakes with biometric detection software Biometric Update Unity Software Plans to Exit Office Space in Bellevue’s Lincoln Square South The Registry Seattle Report: Some older Samsung devices are developing a green line issue after software updates Android Authority Truck Software Developer Platform Science Raises $125M Transport Topics Rockwell Automation Supercharges Response Time with FactoryTalk Remote Access Software Solution Automation.com Further weakness as Asure Software (NASDAQ:ASUR) drops 11% this week, taking one-year losses to 58% Simply Wall St Pharmacy procurement software saves University Hospitals millions Healthcare IT News System Infrastructure Software Market to Reach USD 309.36 billion by 2031 ,Fueled by Growing Complexity of IT ... StreetInsider.com Kansas City’s H&R Block reports software outages on Tax Day Kansas City Star Honeywell introduces AI-enabled software solution for aerospace Arabian Aerospace Omdia: Generative AI software revenue in Asia and Oceania to exceed $18 billion by 2028 StreetInsider.com Alantra Partners Leads Growth Deal for Energy AI-Software Maker GridBeyond - The Wall Street Journal Alantra Partners Leads Growth Deal for Energy AI-Software Maker GridBeyond The Wall Street Journal Zarf: Open-source continuous software delivery on disconnected networks Help Net Security Bull of the Day: CyberArk Software (CYBR) Zacks Investment Research FPT Software Attains Gold Stevie® at 2024 Asia-Pacific Stevie® Awards for Innovation Business Wire Saudi Arabia's Penny Software raises pre-Series A funding Edge Middle East New software advances warp drive design potential KillerStartups Best free data recovery software of 2024 TechRadar |
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 |