Features

Advanced Features

 cViewSQL

cViewSQL is a database utility to process SQL commands against your database.  This can be used with your MS-Access databases to process an action query or any other ODBC compliant database. It replaces two older products (cViewODBCopy and cViewDBUpdate) as well as providing much richer functionality.

Features

You can use cViewSQL to do the following

• Process a SQL command in your database.  This command can delete or update data, create tables or create a temporary summary table.
• Process a text file that contains multiple SQL commands. 
• Upload CSV or tab delimited fields into your tables.
• Export data from your system to send to another cViewSQL user
• Supports any ODBC compliant database (e.g. MS-Access, SQL-Server, Oracle, MS-SQL)
• Recognize duplicate values and remove them prior to the upload into the database.
• You can run cViewSQL from the desktop application, or using a command line.  You can automate cViewSQL with our cViewMANAGER or cViewSERVER schedulers.

Advanced features

cViewSQL includes four basic processes.  Combine these with the other functions and you have a a combined tool that can create your database, load data from an external source, update selected records, and send you the results as a file attachment to an email.

• Email an exception report to you each day as a HTML message
• Run a Crystal report to identify some data that needs 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

For frequently asked questions about our products, please click here for our knowledgebase : FAQs

Cost: US$245.90