Hi Bryant

If I have understood what you want, you would like to connect to a different DB depending on some configuration?

I'm not sure what you are referring to with "of_editdatasource", that must be a function in your own code. PB functions do not have the OF_ prefix.

"Is there a guild line on how to allow multi db connections in Oracle", are you wanting to connect to one database at a time or multiple databases concurrently?

If you are connecting to one DB as once, you have a choice. You can change the transaction objects connection information to specify the SID in the tnsnames.ora. OR you can connect to a SID "saasdb" and edit the tnsnames.ora to have the correct database details. You could always edit the tnsnames.ora with you application as it is only a text file.

If you want to connect to multiple dbs concurrently then you will need to create a transaction object for each connection and then all the options above still apply.

If none of this matches your issue then please give some more details about your database setup.

Thanks

David

Hi Bryant;

   The PowerServer "Dynamic DataSource" feature is the "cats meow" for this type of multi-tenant application design. Have a look at the "appeondconfigdatasource" object and in particular the "of_adddatasource" method. This would allow each tenant to use the same application code but connect to a unique DB instance per client.

   Unfortunately, the "Dynamic DataSource" feature is not supported for Oracle. You will need to create a DB "DataSource" for each tenant manually in AEM.

Regards ... Chris

Hi Bryant,

The appeondconfigdatasource does not support Oracle database, there is no plan to support it currently.

PowerServer supports Dynamic transaction object to data source mapping, you can create multiple 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.

https://www.appeon.com/support/documents/appeon_online_help/2017/server_configuration_guide_for_net/Dynamic_transaction_object_to_connection_cache_mapping.html

You can modify code like SQLCA.DBParm="CacheName='ASADataSource1'" to connect different data sources.

ASADataSource1 is a name of data source.

For example(please note the DBMS of Oracle  12 is O10):

SQLCA.DBMS = "O10"

SQLCA.AutoCommit = False

Choose Case db_name

Case 'PROD'

SQLCA.DBParm="CacheName='appeonsample'"

Case 'DEV'

SQLCA.DBParm="CacheName='appeonsample2'"

End Choose

And you can enable the Dynamic Database Connection option in AEM> Server> Resources> Data Source>[data source name] and specify the user name and password to connect to the database. More details please refer to the Appeon Help > Appeon Server Configuration Guide for .NET> AEM User Guide> Server> Resources> Data Source> Adding a data source section or the online help at:

http://www.appeon.com/support/documents/appeon_online_help/2015/server_configuration_guide_for_net/ch04s03s03.html#Adding_connection_cache

Then you can use the script like below to specify the user/password to connect to the database.

SQLCA.LogId = %your id%

SQLCA.LogPass=%your pass%

Just for your reference, when the Dynamic Database Connection feature is turned on the LogID and LogPass of the Transaction object will be used to connect to the database; when it is turned off then the user name and password specified in the data source will be used to connect to the database.

Regards,
ZhaoKai