Property | Description |
|---|---|
Connection | Name of the Google Cloud Storage target connection. |
Target Type | Type of the Google Cloud Storage target objects available. You can write data to a single or parameterize Google Cloud Storage target object. You cannot write data to multiple objects. |
Object | Name of the Google Cloud Storage target object. Note: Ensure that the column names in the target object do not begin with special characters. |
Create New at Runtime | Creates a target. Enter a name and path for the target object and select the source fields that you want to use. By default, all source fields are used. The target name can contain alphanumeric characters. You can use the following special characters in the file name: ., _, @, $, % If you specify the path, the Secure Agent creates the target object in the path you specify in this property. The Secure Agent creates the target object in the following path: <bucket_name>/<path_name>/<target_object_name> You cannot parameterize the target at runtime. Note: If you specify a delimiter other than comma, the target file is generated with comma as the delimiter. |
Operation | Select insert as the target operation. You cannot perform update, upsert, or delete operations on a Google Cloud Storage object. |
Property | Description |
|---|---|
Google cloud storage path | Overrides the Google Cloud Storage path that you specified in the connection. This property is required when the source is not a flat file. Use the following format: gs://<bucket name> or gs://<bucket name>/<folder name> |
Target file name | Optional. Overrides the Google Cloud Storage target object name. |
Writer header | Determines whether the Secure Agent must write the header to the target file. |
Number of Threads for Uploading Data to the Target | Specifies the number of threads that the Secure Agent must create to write data to the Google Cloud Storage target. You can configure multi-threading to write data to the Google Cloud Storage target in parallel and improve the performance. Set the number of threads based on your system configuration. You might need to test different settings for optimal performance. If you configure more than one thread, you must increase the Java heap size in the JVMOption3 field for DTM under the System Configuration Details section of the Secure Agent. You must then restart the Secure Agent for the changes to take effect. Default is 1. |
Order Target Data | Specifies whether the Secure Agent must retain the order of text data when it writes to the Google Cloud Storage target. You can retain the order of text data if you configure more than one thread to write text data to a Google Cloud Storage target. Note: This property is not applicable for binary and string data types. For example, if you specify five threads to write data to the target and select this option, the Secure Agent writes data to a local file and then splits data across multiple local files. The Secure Agent then writes data from the local files to the Google Cloud Storage target. If you do not select this option, the Secure Agent writes data into five local files, writes data to the target, and then merges the file in the Google Cloud Storage target. Default is selected. |
Success File Directory | This attribute is not applicable for Google Cloud Storage Connector. |
Error File Directory | This attribute is not applicable for Google Cloud Storage Connector. |
Forward Rejected Rows | This attribute is not applicable for Google Cloud Storage Connector. |