Recurso

Databases

The projects created in Scriptcase may be connected to different DBMS (MySQL, PostgreSQL, SQLite, Interbase, Firebird, MS Access, Oracle, SQL Server, DB2, SyBase, Informix, or ODBC layer). Scriptcase manages all the connection to the database in order to ease the creation process and maintenance of applications. Learn more about database features.

Interface
Access to various DBMS

Access to various DBMS

Scriptcase connects to the following databases: MySQL, PostgreSQL, SQLite, Interbase, Firebird, MS Access, Oracle, SQL Server, DB2, SyBase, Informix, or ODBC layer.

Connections to multiple servers

Connections to multiple servers

The Scriptcase projects may have connections to different databases. Scriptcase offers automatic features and macros that manage the dynamic exchange of connections.

Different connection Drivers

Different connection Drivers

For each connections to databases, Scriptcase offers different types of drivers, including for example: PDO and MySQLi for MySQL; Dlib PDO for SQL Server, ODBC.

Import files XLS, CSV and ACCESS

Import files XLS, CSV and ACCESS

Scriptcase offers an XLS, CSV and ACCESS spreadsheet import and conversion features for the databases supported by Scriptcase. With this import tool you can easily transform your spreadsheets into system applications.

Database Builder/Manager

Database Builder/Manager

Build and manage your database using our integrated database manager.

Data dictionary

Data dictionary

Data Dictionary is an important tool for the internationalization and standardization of systems, using this feature it is possible to create a data repository, that can be associated with one or more tables.

Exporting data

Exporting data

Your data can be automatically exported to the formats: XLS (Excel), XML, DOC (Word), PDF, CSV, RTF and printing in grids and PNG, JPG, PDF, SVG and XLS in the Charts.

SQL Builder (Query Manager)

SQL Builder (Query Manager)

Tool that assists in building SQL grids in the form of Wizard. These grids can be saved to be used afterwards.

ER Diagram

ER Diagram

Feature used to assist in database management, in addition to SQL Builder and DATABASE Manager, helps to create ER Diagrams for databases connected to Scriptcase.

SSL for secure connections

SSL for secure connections

Secure Socket Layer (SSL) is a global standard in security technologies. It creates an encrypted channel between a web server and a browser to ensure that all transmitted data is confidential and secure.