Use SSL with dsbulk

How you use SSL encrypted connections with DataStax Bulk Loader depends on your database platform.

Enable SSL on your cluster.
Pass SSL options to the embedded Java driver in DSBulk. While you can do this on the command line, using a configuration file is recommended.

Enclose the Java driver configuration options in the datastax-java-driver { … } block:
```
dsbulk {
   connector.name = "csv"
   connector.csv.delimiter = "|"
   schema.keyspace = "myKeyspace"
   schema.table = "myTable"
   schema.mapping = "0=name, 1=age, 2=email"
}

datastax-java-driver {
  advanced {
    ssl-engine-factory {
      keystore-password = "cassandra"
      keystore-path = "/Users/myaccount/tmp/ssl/keystore.node0"
      class = DefaultSslEngineFactory
      truststore-password = "dse#r0cks!"
      truststore-path = "/Users/myaccount/tmp/ssl/truststore.node0"
    }
  }
}
```
Alternatively, you can create a separate configuration file, such as driver.conf, that contains all the datastax-java-driver properties. Then, reference that separate file in your DataStax Bulk Loader configuration file, by using a statement such as include classpath("driver.conf").

Enclose passwords that contain special characters in quotes, such as truststore-password = "dse#r0cks!".
On the command line, use the -f switch to specify your config file:
```
dsbulk load -f my-application.conf -url file1.csv -k ks1 -t table1
```
If your database requires authentication, provide the username and password using the -u and -p options, respectively.

With Astra DB, SSL encryption is handled automatically in the Secure Connect Bundle (SCB).

Give Feedback