The SAP Connection contains details about the physical location of a single instance of the SAP application server.
Settings Tab
| Field |
Description |
| User Name |
User name |
| Password |
Password |
| Server |
Host name or IP address of the SAP application server (ASHOST name) including the SAProuter string if applicable |
| Client |
Client number |
| Language |
Language |
| System Number |
System identification number |
| Minimum Connections |
The minimum number of connections in the pool at all times. Default: 5. |
| Maximum Connections |
The maximum number of connections in the pool at any time. Default: 10. You will receive an error if attempt to exceed. |
| Growth Size |
Increment by which to increase the number of connections in the connection pool. Default: 2 |
| Shrink Size |
Number of connections that are recycled back to the connection pool after the Idle Time interval. Default: 1 |
| Idle Time |
The interval in minutes after which extra connections in the pool are recycled. After recycling the pool contains only the Minimum Connections. |
Listener Settings Tab
Gateway Options
| Field |
Description |
| Gateway Host |
SAP Gateway Host name (GWHOST name) including the SAProuter string if applicable |
| Gateway Service |
SAP Gateway port name or number (usually sapgwXX or 33XX where XX is the System Number defined in the Settings Tab) |
Transaction Storage Options
The database defined in this section is solely used for SAP IDoc TID management for SAP Outbound Idoc processing. The required table will be automatically created during the initialization.
| Field |
Description |
| Database URL |
Read only field populated as other Connection values are specified. To be used for reference only. |
| Database Type |
Select the appropriate type of database to connect to, such as Oracle, SQL Server, etc. You can select one of the pre-supplied types, or select "Custom" to specify the Connection URL directly. Note: choosing a "Custom" type will typically require you to add the driver to the Atom by copying the driver file(s) into the ..\<Atom root>\lib directory and restart the Atom. |
| User |
Database user name. |
| Password |
Database user password. |
| Host |
The name or IP address of the database server. |
| Port |
The port on which to connect to the database server. Some common defaults:
SQL Server: 1433
Oracle: 1521
Sybase: 5000
Derby: 1527
DB2: 50000
MySQL: 3306
|
| DB Name |
The name of your database |
| Additional Options |
Any additional options to be specified in your DB URL. This will most often take the form of name/value pairs delimited by semicolons
Example: ;instance=DB01
Connect to SQL Server as a Windows user
Example: ;domain=<Your Windows Domain Name>
If you are using SQL Server, connecting as a Windows user, and connecting to a named instance, the order of the properties matters for the JDBC URL
Example: ;instance=<value>;domain=<value> |
Class Name
("Custom" Database type only) |
Fully qualified Java class name of the JDBC driver. Refer to the JDBC vendor's documentation for the class name.
Example: sun.jdbc.odbc.JdbcOdbcDriver |
Connection URL
("Custom" Database type only) |
Refer to the JDBC vendor's documentation for the connection URL syntax. It will often follow a pattern like this:
Example Pattern: jdbc:<database type>://<host>:<port>/<database name>;<additional options name/value pairs>
Example URL: jdbc:mysql//localhost:3306/MyDatabase;option1=value;option2=value |
This page
Other pages
Account
