Microsoft SQL Server Example

Microsoft SQL Server users must include the schema name in the catalog.db parameter, using the following syntax:

catalog.db=catalog database name.schema name

The following is an example configuration for server.properties using a SQL Server database:

catalog.url=sqlserver\://aspen3.us.oracle.com\:1433
server.css.URL=http\://pine4.us.oracle.com\:28080/interop/framework/getCSSConfigFile
catalog.db=esbstudio.root
catalog.username=root
catalog.password=A627FC9A6DEA834C1FA777217871D09E
server.hss.bpmApplication=BPM\:29696
server.datafile.dir=C:/FlatFileSource
server.essbase.streamingCubeBuilding=true 
server.timeoutPeriod=7200
server.queueSize=200
server.threadCount=35
server.resourceCount=25
server.sql.fetchSize=500
server.tempDir=C:/Windows/Temp
server.charset=windows-1251
server.readLockTimeOut=150
server.writeLockTimeOut=150
sqlserver.pool.maxsize=20
sqlserver.cache.size=15
server.essbase.uniqueMemberFromCaptionBinding=true