1 Reply Latest reply on Sep 10, 2014 8:22 AM by Steven Hawkins

    Enable SSL when VDB is configured as a Data Source

    Madhurika Sharma Newbie

      i wanted to know if we can enable ssl connectivity to database(in my case, MS SQL) from Teiid.
      I have configured a VDB as a Data Source and have a configuration of datasource in standalone.xml as :

      <datasource jta="false" jndi-name="java:/Source Name" pool-name="Source Name" enabled="true" use-ccm="false">

                          <connection-url>jdbc:sqlserver://domain:port number;VMI_UAT=database name</connection-url>

                          <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>

                          <driver>sqlserver</driver>

                          <security>

                              <user-name>Username</user-name>

                              <password>password</password>

                          </security>

                          <validation>

                              <validate-on-match>false</validate-on-match>

                              <background-validation>false</background-validation>

                          </validation>

                          <statement>

                              <share-prepared-statements>false</share-prepared-statements>

                          </statement>

                      </datasource>