cViewSQL connects to a database using an ODBC connection. It can process SQL statements in that database. It supports ODBC compliant database (e.g. MS-Access, SQL-Server, Oracle, MS-SQL). It's easy to run! You can manually run cViewSQL from the user interface or from a command line, scheduled in a BAT file. Or, you can schedule it in our cViewMANAGER or cViewSERVER report schedulers. 

1. Bookmark this page, in case you have questions.
2. Complete the license purchase.
3. Download the software (free trial).
4. Install the license key.

• Create your database
• Load data from an external source
• Update selected records
• Send you the results as a file attachment to an email.

cViewSQL empowers you to do such things as:

• Execute an SQL command against the database.
• Execute a series of SQL commands that are in an external text file.
• Upload a text file into a database table.
• Export from the database to a text file, tab delimited file or XML file.
• Generate an HTML page from the data.
• Delete data
• Update data
• Create tables
• Create a temporary summary table
• Copy tables from one ODBC data source to another
• Process a text file that contains multiple SQL commands
• Process an action query on MS-Access databases
• Export data from your cViewSQL system to send to another cViewSQL user
• Recognize duplicate values and remove them prior to the upload into the database.
• Process a SQL update or delete in the database.

But, don't stop there. Using cViewSQL, you can also:

• Process a series of SQL commands from a text file. This works really well with our DISK Output User Function Library. Use a the functions in a crystal report to generate some SQL update statements--then process the file with cViewSQL .
• Generate an HTML or XML page on your Web server with the latest database values.
• Generate CSV or Tab delimited text fields, to transfer the data into another system.
• Upload CSV or Tab delimited fields into a database table.
• Email an exception report to you each day as an HTML message.
• Run a Crystal Report to identify some data that need fixing. Use our Disk Output user function library to write the SQL update statements to fix those records and process them automatically using a cViewSQL command.
• Place multiple CSV files in a folder, and have them all process and upload values into the database.
• Create a cViewSQL task that extracts specific data from a database and saves it as a XML file on your Web server.

This functionality is more than just reporting from your data. It allows you to modify the data and of course requires the appropriate permissions for your database environment.

cViewSQL replaces two of our previous products (cViewODBCopy and cViewDBUpdate), plus it adds major extra functionality. You can run cViewSQL from the desktop application, or using a command line. You can automate cViewSQL with our cViewMANAGER or cViewSERVER schedulers.