Table of Contents

Search

  1. Preface
  2. Starting Data Archive
  3. System Configuration
  4. Database Users and Privileges
  5. Source Connections
  6. Target Connections
  7. Archive Store Configuration
  8. Datatype Mapping
  9. Database Optimization
  10. SAP Application Retirement
  11. z/OS Source Data Retirement
  12. Seamless Data Access
  13. Data Discovery Portal
  14. Security
  15. SSL Communication with Data Vault
  16. LDAP User Authentication
  17. Auditing
  18. Running Jobs from External Applications
  19. Salesforce Archiving Administrator Tasks
  20. Upgrading Oracle History Data
  21. Upgrading PeopleSoft History Data
  22. Data Archive Maintenance
  23. Appendix A: Datetime and Numeric Formatting
  24. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

Creating an SSL Connection

Creating an SSL Connection

To create an SSL connection between a Microsoft SQL Server database and Data Archive, create or edit the target connection.
  1. Log in to the Data Archive UI.
  2. If the connection is available, edit the connection through the
    Administration
    Manage Connections
    menu.
  3. If a connection is not available, click
    Administration
    New Target Connection
    .
  4. Select a Microsoft SQL Server as the connection type.
  5. Enter the connection details to the Microsoft SQL Server.
  6. Add the following attributes to the
    Port
    property:
    [
    Database_Port=xxxx
    ];encryptionMethod=SSL;ValidateServerCertificate=false/true;CryptoProtocolVersion=TLSv1.2
    For example:
    1433;encryptionMethod=SSL;ValidateServerCertificate=false/true;CryptoProtocolVersion=TLSv1.2
    CryptoProtocolVersion
    is the name of the protocol supported by the database server.
    Data Archive uses the
    Port
    value to create an SSL connection between the Microsoft SQL Server database and Data Archive.
  7. Click
    Save
    .
  8. To validate the certificate, you must import the certificate from the SSL enabled Microsoft SQL Server and add it to the respective Java
    cacerts
    file where Data Archive is running.

0 COMMENTS

We’d like to hear from you!