Configuring Authentication for Astra Databases

To connect to an Astra database, you must authenticate your connection by providing a user name, password, and secure connection bundle.

To obtain the secure connection bundle associated with your Astra database, download it from the DataStax Constellation console. For more information, see "Obtaining database credentials" in the DataStax Astra documentation: https://docs.datastax.com/en/astra/aws/doc/dscloud/astra/dscloudObtainingCredentials.html.

To configure authentication for Astra databases :

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, and then click Configure.
  2. In the Mechanism drop-down list, select Cloud Secure Connection Bundle.
  3. In the Username field, type the user name associated with the database.
  4. In the Password field, type the password corresponding to the user name you typed above.
  5. In the Secure Connection Bundle Path field, type the full path and name of the secure connection bundle associated with your Astra database. To make sure that the DSN is compatible with all ODBC applications, escape the backslashes (\) in your file path by typing another backslash, for example, C:\\temp.
  6. To encrypt your credentials, select one of the following:
    • If the credentials are used only by the current Windows user, select Current User Only.
    • Or, if the credentials are used by all users on the current Windows machine, select All Users Of This Machine.
  7. To save your settings and close the dialog box, click OK.