Database Guru James F. Koopmann Reviews DBxtra Reporting and Query Tool

DBxtra is a formidable question and reporting device that hides lots of the complexity and technical experience required for developing connections to disperse information resources, construction queries, designing studies, and supply data during an undertaking or on your buyer base.

With the facility to hook up with more than one databases or information resources on the similar time, DBxtra lets in for pass platform information aggregation and the facility to reply to questions that will most often take IT time emigrate information right into a unmarried reporting database. Through robust question and filtering mechanisms customers be capable to browse and reach fantastic grained retrieval of information to reply to detailed industry questions.

DBxtra makes use of a undertaking stage method and Explorer sort tree construction to categorize database and DBxtra gadgets that facilitates the manufacturing queries and studies. This explorer tree construction significantly improves the reusability of gadgets, velocity in get admission to to data, and decreases the man-hours required to design and bring next studies.

The manufacturing of stories can also be produced in numerous codecs together with HTML, Microsoft Excel, CSV, XML, or PDF with the method to be merged into personalised E-mails. Also to be had is a visible document dressmaker the place your number of formatting choices can also be hired to provide simply the fitting search for your document.

DBxtra comes very on the subject of their function of “no programming or database wisdom required”. All the whilst developing a brand new breed of energy end-users.

Getting acquainted with DBxtra

How a product “feels” is all the time a large worry when handing over a product that can in reality strengthen the productiveness of finish customers and scale back the weight on IT. I individually like to check out a product with out studying the documentation. While I’ve years of revel in as a DBA, analyst, developer, and knowledge modeler I truthfully attempt to block all that data out of my intellect to “really feel” what it might be love to perform beneath restricted expectancies. The simplest mind-block I had to recover from used to be double clicking on gadgets to turn on their utilization. Honestly if I might have learn the lend a hand at the best and backside of the monitors this can have been eradicated.

DBxtra has a really nice step-by-step method, virtually like an Install Shield method, that drives you via advent of queries and studies. Once getting use to clicking via this stepwise method I used to be construction queries and studies sooner than I may recall to mind examples to style. All of which I didn’t wish to know the rest about information fashions rather than identity of which database my tables the place. The simplest database modeling ideas that finish customers wish to perceive are tables, columns, joins, filters, sorting, and combination purposes. All of that are very teachable and maximum finish customers perceive a big subset of those ideas.

DBxtra comes with a load of documentation together with tutorials and video streams. All of that are very useful and can stroll you in the course of the primary options of this product. I watched the entire educational movies and collected some precious hints on tips on how to use the product. It could be very odd for distributors to visit this period to teach their finish customers. I learn this as a real dedication at the supplier’s facet to verify you’ll be able to use the product and it to not change into shelf-ware. Very admirable!

Another coaching help is the cargo of a pattern information supply, with queries, studies, and schedules. This permits you to temporarily dive into the product and get a just right really feel for the product with out ever touching your information resources. Of route you’ll sooner or later wish to produce some queries and studies in opposition to your databases as there may be not anything higher for figuring out the effectiveness and usability than seeing your personal information.

Corporate Profile

Quanticus S.A. de C.V. is a tool developer positioned in Querétaro, México.

We have extra then 10 years revel in in creating database tool gear and ERP tool for the small and medium sized corporate.

Our team of workers contains four administrative, eight gross sales, 6 make stronger and 12 builders folks.

The corporate used to be established about four years in the past.

The product DBxtra used to be launched November 2004.

Morelos 166B

Col. Centro

Querétaro, Qro. C.P. 76000

México

Tel.: +52 (442) 215 44 96

USA: (201) 399 22 18

Problems Solved

Can your finish customers get to the information they want? How ceaselessly do they wish to look ahead to a developer to supply help within the extraction of necessary data? It does now not subject in case you are a part of the chief crew or an finish person. Often instances when you need to get to data from a database or limited device you wish to have to request paintings to be carried out for your behalf. You are on the mercy of your IT team of workers and particularly builders, information analysts, information directors.

With DBxtra finish customers are liberated from the ever-increasing queue this is skilled each and every time they want IT team of workers to provide studies or extract information. DBxtra lets in customers to get admission to more than one information resources in disperse database techniques and pull data from those resources in a scientific pint and click on style. The ease through which it’s to provide studies, and extra importantly modify studies when industry laws trade, can have a drastic affect and higher productiveness in your finish customers whilst additionally lowering the weight on IT.

Since DBxtra can connect with maximum any database or information supply, you’ll supply a device the is really cross-platform impartial. This in reality reduces the toolset required, supplies a unmarried get admission to level to information, and decreases coaching necessities.

Who must use it

Anyone who desires to provide high quality studies or simply question information in an advert hoc manor can take pleasure in DBxtra. With a formidable toolset DBxtra assists finish customers in addition to the IT team of workers. within the categorization and processes round defining the place data is, how it’s retrieved, and who wishes the ideas. Developers, analysts, and DBAs will take pleasure in this device as they interrogate information throughout more than one techniques.

Working with DBxtra

Below is gifted with my studies operating with the DBxtra product. While the demos and tutorials take you via lots of the function set it’s extremely advisable you employ the product to look the way it works for your setting.

When you first get started up DBxtra you might be induced to simply accept the license settlement after which wish to create a DBxtra database for housing studies. Within the listing you provide to accommodate the DBxtra database a brand new listing will probably be created together with a .mdb (Microsoft database) document. While the use of DBxtra further directories and recordsdata could also be created on this listing. I used to be then induced to create an administrator password for the Microsoft database after which required to login. These few setup procedures and simplest wish to be carried out as soon as and weren’t time in depth.

All paintings is finished via tasks and it is important to create one prior to generating any document or querying any information. After you’ve got outlined a undertaking you’ll outline the connections to databases and upload database gadgets to make use of throughout the newly created undertaking. I used to be more than pleased to revel in an error loose mechanism for developing connections to Oracle, SQL Server, and Microsoft Excel.

After defining a undertaking and including database gadgets to it you might be then put into the Data Explorer. The Data Explorer is the center of the organizational device for DBxtra the place you get admission to and position gadgets akin to database gadgets, studies, and queries. Data Explorer is a tree construction that, as you get acquainted with the toolset, lets in for simple retrieval and fast get admission to to prior to now outlined gadgets. At this level this is a great position to click on the “Show Data” choice and turn out to your self the convenience at which DBxtra can extract data from other information resources. You might also at this level get acquainted with probably the most extra robust filtering mechanism in the course of the “Show box values” choice. With this option you’ll extract values for an object that can be utilized in equality suits on columns. Just click on the “Show box values” field, make a selection a box for the equality operation, and magically you’ll use the drop down record and assign a price for the equality. Powerful and really user-friendly. Now simply hit the “Show Data” button to go back the filtered end result set.

Query Builder lets in for the definition and saving of queries throughout the Data Explorer tree construction. Defining a question is completed via naming the question, settling on information resources, settling on gadgets for the question, construction dating and filters the place vital, after which most likely sorting the information. As you employ DBxtra you’ll quickly realize that tabs around the best of the monitors provide the order through which you must practice. It is a straightforward option to outline the item or process you might be construction and really intuitive on the similar time. I individually like issues that experience a certain waft and DBxtra supplies that for me.

Building studies the place once more simply as simple. Just practice the script offered within the tabs at the display. Reports be capable to be exported to textual content, XML, PDF, Microsoft Excel, and HTML. A novel function of the DBxtra is to export the report back to a Microsoft Excel pivot desk and chart the place the Excel spreadsheet is pre-built with a relentless connection to the information resources. Whenever the database is up to date and the person of the Excel document presses the refresh button the information within the spreadsheet could also be up to date.

Other choices that I didn’t check out have been the E-mailing and scheduling of stories. I did watch the demos and seemed on the monitors. Again the typical thread of the step-by-step tabular method existed in those choices and thus offered no surprises. An fascinating function used to be the facility to jot down a easy email merge operation that permits for the sending of a document in an e mail whilst tailoring the email on merge fields for customization.

Hardware / Software Requirements

• Processor 600Mhz

• 128 MB RAM

• 25 MB to be had house on arduous disk power

• Microsoft Windows 98 SE or later

• Microsoft Excel 97 & Outlook 97 for upper stage options

Download and Installation

You can get a loose 15 day trial off DBxta’s internet website online at [http://www.dbxtra.com/DBxtra/registro.asp]

If you wish to keep up a correspondence with DBxtra and obtain some loose make stronger and different precious details about the use of the product while you’re in trial you then must give them your identify. But identify registration isn’t required for the loose trial. As a fascinating function to the obtain, if you make a decision not to acquire via the tip of the trial the product deprecates itself from the Professional Edition into the Free Edition. I’ve by no means noticed this prior to and prefer the concept that since you don’t wish to concern about taking out the product. Plus on the finish of the trial you continue to have a product this is usable. The obtain and set up went very abruptly with a blank and only a few clicks to put in the tool.

License

There are 3 distinct merchandise for DBxtra that come with a typical, skilled, and document viewer. After an ordeal length of 15 days the product deprecates to a loose model. Pricing is these days to be had for a unmarried concurrent person and you might be given worth breaks because the selection of concurrent customers building up. This levels from round 25%-33% relying on what number of licenses you purchase. Also to notice is that the license is for concurrent customers and now not for put in copies of DBxtra. This signifies that you’ll set up all over and use the place you favor. The pricing could be very affordable personally and relying at the selection of licenses you buy you’ll put the facility of information extraction into finish customers for lower than $150 USD. Support is loose as are upgrades for yr 2005.