Set up Write Back in a Connection Pool

A connection pool's write back requirements include a temporary table and bulk insert properties.

See About Setting the Bulk Insert Buffer Size and Transaction Boundary Settings.

The table describes the properties in the Write Back tab of the Connection Pool dialog.

Property	Description
Database supports unicode	Select when the columns are of an explicit Unicode data type, such as NCHAR, in a Unicode database. This makes sure that the binding is correct and that data is inserted correctly. Different database vendors provide different character data types and different levels of Unicode support. Use these guidelines to determine when to set this option: On a database where CHAR data type supports Unicode and there isn't a separate NCHAR data type, don't select this option. On a database where NCHAR data type is available, it's recommended to select this option. On a database where CHAR and NCHAR data type are configured to support Unicode, it's optional to select this option. Unicode and non-Unicode data types can't coexist in a single non-Unicode database. For example, mixing the CHAR and NCHAR data types in a single non-Unicode database environment isn't supported.
Temporary Table - Prefix	Enter the first two characters in the temporary table name that the Oracle Analytics query engine creates.
Temporary Table - Owner	Enter the table owner name used to qualify a temporary table name in a SQL statement. For example, owner.tablename. If left blank, the user name specified in the writeable connection pool is used to qualify the table name.
Bulk Insert - Buffer size (KB)	Enter the maximum number of bytes inserted into a database table. For optimum performance, set this parameter to 10240.
Bulk Insert - Transaction boundary	Enter the batch size for an insert in a database table. For optimum performance, set this parameter to 1000.

Use these steps to specify your database's write back properties.

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Physical Layer and locate and double-click a database.
4. In the database's tab, click Connection Pools.
5. In the connection pools list table, click a connection pool to select it and then click Detail view to open the properties pane.
6. Scroll to Write Back and specify the write back properties.
7. Click Save.