Knowledgebase
Knowledgebase: Coding
Appeon - Dynamic Transaction object to data source mapping
Posted by Carmina Garcia on 15 March 2016 11:52 AM

Appeon supports Dynamic transaction object to data source mapping, you can create two data sources to connect different database. Please refer to the following steps:
1. Add data source pointing to different database in AEM;
2. Follow below online help documentation to setup transaction object to data source mapping using dynamic transaction in Appeon Web Application rather than doing it in AEM.
http://www.appeon.com/support/documents/appeon_online_help/2015/server_configuration_guide_for_net/ch03s05s01.html

You can modify code like SQLCA.DBParm="CacheName='ASADataSource1'" to connect different data sources.
ASADataSource1 is the name of a data source.
and please use the correct SQLCA.DBMS based on your database type.

For example: 
SQLCA.DBMS = "ODB-ASA"
SQLCA.AutoCommit = False
SQLCA.DBParm = "CacheName='appeonsample'"

connect;
// your script


/////////////////////////////////////////////////////////////////////////
disconnect;

SQLCA.DBMS = "ODB-MYS"
SQLCA.AutoCommit = False
SQLCA.DBParm = "CacheName ='appeonsample2'"

connect;

// your script

(0 vote(s))
Helpful
Not helpful

Comments (0)
Help Desk by Novalys