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.
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
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
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
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
Build and manage your database using our integrated database manager.
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
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)
Tool that assists in building SQL grids in the form of Wizard. These grids can be saved to be used afterwards.
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
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.