List of required configuration parameters for the S3 to CDW ReadyFlow
When deploying the S3 to CDW ReadyFlow, you have to provide the following parameters. Use the information you collected in Prerequisites.
|CDP Workload User||Specify the CDP machine user or workload user name that you want to use to authenticate to the object stores (via IDBroker) and to the schema registry. Ensure this user has the appropriate access rights to the object store locations and to the schema registry.|
|CDP Workload User Password||Specify the password of the CDP machine user or workload user you are using to authenticate against the object stores (via IDBroker) and the schema registry.|
|Destination Database Driver||Upload the database driver jar file for your destination database.|
|Destination Database Driver Class Name||Specify the destination database driver class name, for example,
|Destination Database Table Name||Specify the destination database table name.|
|Destination S3 Bucket||Specify the name of the destination S3 bucket you want to write
to. The full path will be constructed out of
|Destination S3 Path||Specify the path within the destination bucket where you want to
write to. The full path will be constructed out of
|Impala JDBC URL||Specify the Impala JDBC URL from the CDW Virtual Warehouse. Do
not include the UID and PASSWORD connection parameters.
The full JDBC URL will be constructed from:
where PWD value is provided by the dynamic property SENSITIVE.PWD in the Impala connection pool service configuration.
|Schema Name||Specify the schema name to be looked up in the Schema Registry used to parse the source files.|
|Schema Registry Hostname||Specify the hostname of the Schema Registry you want to connect to. This must be the direct hostname of the Schema Registry itself, not the Knox Endpoint.|
|Source S3 Bucket||Specify the name of the source S3 bucket you want to read from.|
|Source S3 Path||Specify the path within the source bucket where you want to read files from.|