Crystal Reports Tools: Improve Performance While Saving Time and Money

cView SQL: Process SQL commands against a database

 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).

Pricing | Buy Now

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.

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.

• Crystalkeen is a subsidiary of Mindconnection LLC.
• Crystal Reports is a subsidiary of Business Objects, which is owned by SAP.
• Questions? Please write to sales @ mindconnection.com. We do want your business.
• Click here to see the latest solutions from Crystal Reports.
• Use Business Objects products to turn reports into true business intelligence tools.