How to view Databases 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 Manager can be used by intermediate to advanced database users to view and change database data.

Opening the Database Manager

You can access the Database Manager from the menu [Database]->[Open Databases] or you can also access the Database Manager from the side panel on the left side of InfoFind under [Database]->[Open a Database].

Viewing and Editing Databases

Viewing and editing databases with InfoFind is easy. Your databases are saved in a list on the left side of the form. A filter at the top allows you to quickly filter through the tables and database objects to help you find what you are looking for. This is useful for large databases and will work even when a database has 10’s of thousands of tables. On the upper-right of the form is a work area where you can run database commands (SQL Statements). Whenever you click on a database object from the list on the left side a command will appear on the right and the results will appear in the bottom-left.

InfoFind Database Form

Connecting to a Database

To add or change database connections open the [Database Connection] dialog from the main database toolbar. With this form you can specify a number of options on how to access a database.

InfoFind Database Form


When you click the […] button to build the connection string you will see the Data Link form. This form will allow you to choose how to connect to a database. To learn where to download database drivers click here for a support topic with related links.

InfoFind Database Form

Creating Reports

Exporting your database queries to reports is very easy with InfoFind. To create a formatted Excel Report click on the Excel button in the Database Toolbar.

InfoFind Database Form


To export to other formats such as CSV or XML click on the Export button in the Database Toolbar and then select a report type and choose a file to save too.

InfoFind Database Form

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.