Home
PowerServer Web
| PowerServer Mobile
Appeon Documentation Center
JavaScript is disabled on your browser. Please enable JavaScript to enjoy all the features of this site.
Home
PowerServer Web
| PowerServer Mobile
Appeon Documentation Center
PowerServer Configuration Guide for .NET
Database Connection Setup
Sidebar
Prev
|
Up
|
Next
| Download PDF
Advanced configurations related with database connection
Application security
Appeon security
Contents
Search
Server Configuration Tasks
Scope of configurations discussed in this book
Configuration stages and tasks
Configuration during application deployment
Configuration during debugging
Configuration during security management
Configuration during performance management
Configuration during server information management
Configuration for emergency control
PowerServer Monitor
Overview
Launching PowerServer Monitor
Configuring Monitors
General tab
Common Monitors tab
Recycle Monitor tab
Mail Settings tab
Log Settings tab
Understanding the information in monitor window
Database Connection Setup
Overview
What is PowerServer data source?
Supported Database Drivers
Setting up PowerServer data sources
Data source settings for ODBC driver
Data source settings for SQL Anywhere .NET Data Provider
Data source settings for Oracle native driver
Data source settings for SQL Server native driver
Data source settings for Informix native driver
Data source settings for MySQL native driver
Data source settings for ASE native driver
Data source settings for Teradata native driver
Data source settings for IBM DB2 native driver
Data source settings for PostgreSQL native driver
Setting up transaction object to data source mapping
Dynamic transaction object to data source mapping
Static transaction object to data source mapping
Advanced configurations related with database connection
Application security
Database security
Predefined data sources
Using INI files for connection security
Appeon security
Incorporate Appeon security in PowerBuilder code
Database auditing
Re-configuring database auditing functionality
AEM User Guide
Introduction
Overview
AEM Tools
Supported Web browsers
Getting started
Running PowerServer
Starting AEM
AEM URL
Three ways to launch AEM
AEM user name and password
Installing Appeon Workspace
AEM language
AEM Help
Server
Sessions
Active Sessions
Viewing active sessions and devices on a PowerServer
Viewing active sessions
Viewing active devices and sessions that belong to the device(s)
Killing session(s) and device(s)
Killing session(s)
Killing device(s) or session(s) that belong to the device(s)
Active Transactions
Viewing active transactions
Rolling back active transaction(s)
Deployment Sessions
Logging
Viewing logs
Log mode
Replace log files
Resources
Cluster
Cluster Server List
Important requirements
Adding a PowerServer
Removing a PowerServer
Checking status of PowerServer
Load Balancing Settings
Failover Settings
Session backup
Heartbeat backup
Synchronizing AEM settings to servers in a cluster
Data Source
Adding a data source
Editing a data source
Deleting a data source
Testing a data source
Maintenance
Auto cleanup
Manual cleanup
Configuration Backup
License Management
Internet connection
Online license activation
Activating an online license
De-activating an online license
Offline license activation
Activating an offline license
De-activating an offline license
Offline License Renewal
Server Security
AEM login
User Management
User Management
Adding a new user
Editing an existing user
Deleting a user
Appeon Workspace Client (Mobile only)
Viewing Appeon Workspace clients
Adding an Appeon Workspace client
Editing an Appeon Workspace client
Deleting an Appeon Workspace client
Group Management
Group Management
Viewing groups
Adding a new group
Editing an existing group
Deleting a group
Appeon Workspace Group
Viewing Appeon Workspace user groups
Adding an Appeon Workspace group
Editing an Appeon Workspace Group
Deleting an Appeon Workspace Group
User and Group Management at LDAP server side
System Security
Security Toggle and Security Type
LDAP Interface Settings
Limitations
LDAP Interface Settings in AEM
Importing certificate file of LDAPS
Deployment Security
Application
Configuration Summary
Transactions
Transaction Objects
Configuring transaction object mappings
Adding a transaction object mapping
Modifying an existing transaction object mapping
Deleting an existing transaction object mapping
Timeout
Session timeout
Transaction timeout
Download timeout
Request timeout
Rollback Completion time
Maximum Rollback Retries
Local Database
Viewing local database connections for an application
PB Features
Registry Mode
INI Files
INI File Mode
INI Files
DLL/OCX Files
Install mode
Conflict Resolution Mode
Decimal Precision
Web service DataWindow
Web Browser
IE Compatibility
IE Browser Interface
Client Features
Application Title
Web Application Theme
Web Application Auto Update
Run Mode
Error Message Mode
Start & Exit
Allow user to select run mode
Default run mode
Exit Mode
Client Storage Location
Client Logs
Retina Display
Data Transfer
Charset
Configuring database Charset for a data source
Updating a Charset
Deleting a Charset
Charset options given in the Charset fields
Encoding
Performance
Multi-Thread Download
Application Server Cache
What is Application Server cache?
Modifying the Application Server cache settings for an application
DataWindow Data Cache
Dynamic-DW SQL Cache
DataWindow Object Cache Settings
Configuration required for database servers
Configuration required for AEM
Client Security
User Authentication
Viewing the current settings
Modifying the security settings of an application
Appeon Workspace
Introduction to Appeon Workspace
Setting Appeon Workspace Security
Assigning access permissions
Mobile App Distribution
Requirements
iOS IPA file requires to be installed through HTTPS
File size requirement
Upload standalone mobile apps and Appeon Workspace
QR code generation for mobile application(s)
Mobile UI Resizing
Screen Size
Adding a device
Editing a device
Deleting a device
Window Size
Configuring size for all windows
Configuring size for an individual window
Search Highlighter (On/Off)