Importing from a Database

Database Connection User Guide > Importing from a Database

PV‑WAVE’s powerful database connection functions let you import data from an external database into PV‑WAVE.

Once the data is imported, you can use PV‑WAVE to analyze, manipulate, and visualize the data. The database connection functions include:

DB_CONNECT Function—Connect to an external database.

DB_GET_BINARY Function—Connect to an external database.

DB_SQL Function—Query the database with SQL SELECT statements and import the results into a PV‑WAVE table.

DB_DISCONNECT Procedure—Disconnect from the database.

NULL_PROCESSOR Function—Facilitates the use of the Null_Info keyword for the DB_SQL function by extracting the list of rows containing missing for one or more columns.

note	Currently, only Oracle databases are supported. Additional databases may be supported in the future.

Use the SQL Syntax You Already Know

You can query your database from PV‑WAVE using the standard SQL statements of the Database Management System (DBMS) that you are accessing. You do not need to learn new SQL syntax.

Import Any Data Type

You can import any data type that is supported by PV‑WAVE. Date data is automatically converted to PV‑WAVE’s date/time format.

Database Access is Convenient

If you can access the database from the workstation on which PV‑WAVE is running, you can connect to the database from within PV‑WAVE.

If you have trouble connecting to a database from PV‑WAVE, contact your database administrator.

What You Need to Know to Use these Functions

The database connection functions are easy to use if you are familiar with the target DBMS and Structured Query Language. Because imported data is placed in a PV‑WAVE table structure, you need to be familiar with the functions used to manipulate tables in PV‑WAVE. These functions are described in the PV‑WAVE User’s Guide.

Version 2017.0