How To Config SQL Intelligent

1) Install JDK by running jdk-6u45-windows-i586.exe
No changes in default settings required.
2) Install Tomcat by running apache-tomcat-6.0.37.exe
Please use directory like C:\Tomcat
3) Go to System properties -> Advanced -> Environment variables -> System variables
Create new variables:
JAVA_HOME			C:\Program Files\Java\jdk1.6.0_45\bin\
4) Stop Tomcat in services if it is running
Find service "Apache Tomcat 6"
5) Configure UTF-8
Edit Tomcat\conf\server.xml
and add useBodyEncodingForURI="true" into connector for port 8080
<Connector port="8080" protocol="HTTP/1.1" useBodyEncodingForURI="true"
               redirectPort="8443" />
6) Configure maximum heap size
Maximum heap size: this is the maximum amount of heap memory the Java Virtual Machine (JVM) is allowed to allocate. For most JVMs, the default setting of the maximum heap size is 64MB. You can increase the maximum heap size of applications by setting the -Xmx JVM parameter. For example -Xmx1024m allows maximum 1GB (1024MB) heap to be allocated for the JVM.
Note: it is recommended to specify a considerably lower value than the amount of physical RAM in your system, so the operating system and other applications will also have enough space. Otherwise the swap memory of the operating system will be used, which can result in high disk activity, and reduced system performance.
7) Run Tomcat in Services
8) Go to Apache Tomcat 6 properties in Services and change Startup type to Automatic
9) Use web brouser
Click on Manager and deploy SqlStream.war
10) Click to SqlStream or use link
11) You are on the configuration screen.
a) Insert your DB server
b) Insert DB server listener port
c) Insert DB server instance name/service/SID
d) Choose type of user login
  I) Oracle DB type - every user has his own account in your database
  II) Oracle EBS type - every user has his own account in your Oracle EBS system
e) Insert DB account and DB password
- For User type (I) it will not be saved and it is only for DB connection control.
- For user type (II) it will be saved and used for every contact with DB.
f) Insert your ADMIN user - this will be controlled against real users
g) After DB connection is successful and ADMIN is correct you can go to SQL Intelligent
12) Make you own SQL forms


  • New services for you

    For the sake of improvement of ATTEYA Group services and a higher knowledge of users we have prepared and launched an independent blog environment for hints, opinions, questions ...
  • SQL Intelligent BI Reporting Tool

    The BI SQL Intelligent application makes it simple and easy to publish SQL queries on a web portal--to obtain information from within a company, SQL Intelligent all ...
  • How To Config ApplStream

    1) Install JDK by run jdk-6u45-windows-i586.exe 2) Install Tomcat by run apache-tomcat-6.0.37.exe Please use directory like C:\Tomcat 3) Go to the Sys ...
  • SQL Intelligent

    Module– A form defined by individual entities su ...