Oracle Connection - Scriptcase

Oracle Connection - Scriptcase

On several occasions we face slowly at the time of connection to the database or the editing and running applications.
  To resolve this issue we can set the connection filter for the loading of data is optimized. To do this, follow these steps:


Step 1 - Connection creation
  Access the menu Database > New Connection to create a new connection in your project.



Step 2 Select the database
   Select the database (in our "Oracle" case).



Step 3 Configuring connection parameters
   In this step we should configure the following items:

 Connection Name - You can use any name to identify the connection. (In our case we used the standard "conn_oracle")
 DBMS Driver - You must select the appropriate connection driver according to the Oracle database.
 Database Name - We can use directly  the ip/TSNAME to make the connection to the desired database

— Schema - Here we can define the Schema used in this connection
 Username - Oracle Database User
 Password - Oracle database password
And click on the icon Test Connection”.



Step 4 Configure the connection filter
  At this time, we must perform the steps below to optimize the configuration of our connection to the Oracle database

 — Show - We choose which database items will be displayed at the creation of applications.
 — Searches - Here are two items that can be configured:
  Tables You can type the name of the tables to be displayed or not.
 — Owner We must use the name (always capitalized) of SCHEMA, to be displayed or not in the list of tables at the time of application creation.
 — Show - Choose whether the data entered in "Tables" and / or "Owner" will be displayed or not.

In this example below, only data from SCHEMA "SYSTEM" will be displayed at the creation of applications



Following these steps, we avoid loading all SCHEMAS or database tables decreasing the amount of data that is requested to the database, increasing the speed of creating, editing and execution of applications.

    • Related Articles

    • Oracle Connection - Scriptcase 8.1 - Linux

      To enable the connection to Oracle on Linux, we must perform the following steps: Prerequisites Step 1  -  Add the i386 architecture and install the packages below : UBUNTU\DEBIAN CENTOS\RHEL - sudo dpkg —add-architecture i386 
- sudo apt-get update
 ...
    • Oracle Connection - Scriptcase 9 - Linux 64 Bits

      This procedure will only work if you have a Scriptcase manual installation in your server. Installing PHP 7.0 Installing the Scriptcase Manually To connect with Oracle in a Linux System, we must follow these steps below: Step 1 -  Installing these ...
    • Filter Connection

      Some databases use schemes to organize internally their data, just like Oracle, PostgreSQL, and SQL Server. Such feature is great when known and used correctly. The problem is when the database has a lot of schemes, that results in delay at the time ...
    • DB2 connection - Scriptcase

      Enabling DB2connection on Scriptcase:   1. Download the instant client of DB2 form the url below or download the file in the final of this tutorial.   - Data Server Driver Package 10.5 - http://www-01.ibm.com/support/docview.wss?uid=swg27016878 ...
    • DB2 Connection - Scriptcase 8.1 - Linux

      To enable the connection to DB2 on Linux, we must perform the following steps: Prerequisites Step 1  -  Add the i386 architecture and install the packages below : UBUNTU\DEBIAN CENTOS\RHEL - sudo dpkg —add-architecture i386 
- sudo apt-get update
 - ...
    • Popular Articles

    • Examples for diagrams

      This tutorial shows how you can import and use the new examples for diagrams released with Scriptpcase V9.2.16.  The applications were created using the components: Jsmind, JKanban e Orgchart.  - Sample 1: Mind Map diagram Click here to  execute the ...
    • Oracle Connection - Scriptcase 9 - Linux 64 Bits

      This procedure will only work if you have a Scriptcase manual installation in your server. Installing PHP 7.0 Installing the Scriptcase Manually To connect with Oracle in a Linux System, we must follow these steps below: Step 1 -  Installing these ...
    • Correcting access error for the Scriptcase database

      Sometimes we encounter an error accessing the Scriptcase database itself, as shown in the image below:   This problem happens when we change the folder name of the scriptcase to another name, such as "sc". Then, the error happens because the complete ...
    • Necessary libraries to install the Scriptcase in Windows 7

      To install Windows 7 SP1, you need to verify that the system has the following items installed: * Visual C ++ Redistributable Packages for Visual Studio (2008) x86 and x64. * Visual C ++ Redistributable Packages for Visual Studio (2010) x86 and x64. ...
    • Manual Update - Windows

      Before performing any procedure we recommend performing a backup of your projects. To back up Scriptcase: Go to Settings > Administration, in the side menu go to Services > Backup. A file (.ZIP) will be generated with all your projects, save this ...