How to find Database Data with InfoFind

Introduction

Databases are very useful if you want to keep track of information. InfoFind works with all popular databases and allows you to view and make changes to any database on your computer or network. The Database Finder is useful for database designers and developers. Business analysts and accountants who need to search through databases may also find this form useful.

Opening this Form

You can access this form from the menu [Database]->[Data Finder] or you can also access this from the side panel on the left side of InfoFind by clicking on the link [Database]->[Data Finder].

Searching for Information in a Database

With InfoFind you can search through an entire database to find search criteria such as a text phrase or number anywhere in the database. After searching though a database InfoFind will list all table and field names were the data was found and how many times it’s in each field.

InfoFind Database Data Finder

Example Usage

Often Databases are very large containing hundreds or thousands of tables and the format of the database will likely not be known by everyone working on it. You can use this form to help determine the format of a database or the location of data in a database. For example searching for a text value might help determine a look up table containing the data and then searching for the ID field from the text value can help determine what tables and records are linked to the data.

Connecting to a Database

To use the Database Data Finder you must first define the database that you want to search through. You can do this by clicking on the […] button. Databases are saved each time you close and open InfoFind and Databases accessed through this form can also be accessed with the standard Databases Form.

InfoFind Database Connection

Using this Form

After you select the database that you want to search you can create the most common queries that you would run using controls under [Quick Options]. The query that will be ran against all or filtered fields in the database is under [Basic Options]->[Query to Run]. You can change values in both Quick Options and Advanced options to define how to run the queries. The Quick Options section specifies the SQL Statement that will be ran against all matching fields, allows for the type of field to be selected, and if system tables are going to be searched. The Advanced Options section specifies the queries that will be used to find table and fields in the database and filters for field types, table names, and field names. To change any of the filter values enter only what you want to find separated by commas (for example the setting [Field Name] = “Name, Value, Option” would only run the query against fields with the exact name). After the search settings have been specified click the [Run] button at the bottom of the form to start the search.

InfoFind Database Data Finder Options


The time it takes to search through a database will vary greatly depending upon how large the database and how many tables and fields that you are searching. While the search is running you will see a progress indicator of how many queries have completed. You have the ability to cancel the search by pressing the [Stop] button.

InfoFind Database Data Finder Data Search


After the search completes you will see a list of all matching results along with a summary report.

InfoFind Database Data Finder Summary Report


By clicking on [Excel Report] or [Web Report] you can export the results to a report in the desired format.

InfoFind Database Data Finder Web Report


InfoFind Database Data Finder Excel Report

Database Definitions

You can modify or add database definitions from the Database Description editor. To learn how to do this, see the topic Database Defintions.