Sql Server Pdw Connection Element
X-Ref:
- Ast Sql Server Pdw Connection Node
- Ast Db Connection Node
- Ast Connection Base Node
Attributes
| Attribute | API Type | Default | Description |
|---|---|---|---|
| ConnectionString | String | This value specifies how to open the connection for the specified data source. This is a required property | |
| Name | String | Specifies the name of the object. This name can be used to reference this object from anywhere else in the program. This is a required property | |
| StagingDatabase | String | Specifies the name of the database that is used as a staging database for the data to be loaded. The data will first be loaded into this staging table. The data will then be asynchronously transferred to the final destination table by the PDW instance. This is a required property | |
| CreateInProject | Boolean | False | This value specifies whether the Connection should be created as a ConnectionManager within each SSIS package that uses it or as a shared ConnectionManager for each project that uses it. |
| CreatePackageConfiguration | Boolean | True | This value specifies whether a PackageConfiguration should be created for this connection. |
| DelayValidation | Boolean | False | This value indicates that the connection should not be validated (tested to make sure that it points to a valid resource) until immediately before it is used. |
| EncryptData | Boolean | False | Specifies whether or not the data should be encrypted |
| HostNameInCertificate | String | Specifies the host name that is used in the certificate. This property value is only used when VerifyServerCertificate is set to true. | |
| LoaderPort | Int32 | 8002 | Specifies the network port that should be used for the loader. The default is 8002. |
| LogicalDisplayFolder | String | string.Empty | Specifies a path that should be used for organizing the tree display of this object in the Logical View in BimlStudio. |
| MaxActiveConnections | Int32 | 0 | This value specifies the maximum number of concurrent connections allowed. |
| Qualifier | String | Specifies the qualifier that should be used for the connection. | |
| RetainSameConnection | Boolean | False | This value indicates whether the same connection can be used for multiple tasks. |
| UseSystemCertificateStore | Boolean | False | Specifies whether the system certification store should be used. If false, the user certificate store is used instead. This property value is only used when VerifyServerCertificate is set to true. |
| VerifyServerCertificate | Boolean | False | Specifies whether or not the server certificate should be verified when connecting. |
Singleton Children
| Child | API Type | Description |
|---|---|---|
| <AnalysisMetadata /> | AstAnalysisServicesConnectionMetadataNode | The SQL Server Analysis Services (SSAS) connection information node specifies supplemental information that is used by SSAS to connect to a given data source, usually in context of development and cube processing. |
Collection Children
| Child | API Type | Description |
|---|---|---|
| <Annotations> <Annotation /> </Annotations> | AstAnnotationNode | This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code. |
| <Expressions> <Expression /> </Expressions> | AstPropertyExpressionNode | This is a collection of SSIS expression definitions for connection property value overrides. |