cViewSQL Command Processor

cViewSQL Command Processor

cViewSQL Command Processor

Price: $245.90

Quantity in Cart: None


Summary

cViewSQL is a powerful database utility that lets you process SQL commands against a database using an ODBC connection. It supports ODBC compliant database (e.g. MS-Access, SQL-Server, Oracle, MS-SQL). Unlike many other SQL command processores, it's easy to run. Free 30-day trial.

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

Features

  • Connects to any SQL data source.
  • Simple Windows application.
  • Can export data to CSV, HTML or XML.
  • Can export data to disk or email.
  • Central database password security control.
  • Can be scheduled using our cViewMANAGER or cViewSERVER report scheduler. You can even use the Windows task scheduler.
  • Log can be local to each application or saved centrally to cViewSERVER or cViewMANAGER log.

Uses

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.
  • Send you the results as a file attachment to an email.

And you can:

  • 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 (with the appropriate permissions for your database environment).

 

Compatible with Crystal Reports XI and can process all prior versions of Crystal Reports.

Benefits

  • Easy to Learn. SQL (Structured Query Language) is the industry standard for creating and updating relational databases. cViewSQL is a simple application to use that language to interact with your database.
  • Simple file exports. cViewSQL can export your data to HTML, XML, CSV, and a CSV line format. You can then use the file you create to upload into another database. The extract can be saved to disk or attached to an email. The HTML format can present a simple table of data in the body of an email message.
  • Powerful bulk updates. Use a Crystal Report or some other reporting tool to identify records that need some fields updated and the new field values and create a text file with multiple INSERT and UPDATE SQL commands. Then use cViewSQL to process that against all the records in your database table.
  • Automate your business process. cViewSQL can be scheduled as a task in our cViewSERVER or cViewMANAGER schedulers.
  • Improved Management. cViewSQL creates a log file of all the activities in the tasks it does. It will also load information into the cViewSERVER or cViewMANAGER log files so all your process history can be viewed in one location.

Free Trial

Customer Reviews
Average Customer Review: Not yet rated
Write an online review and share your thoughts with others.

There are no reviews