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>
You'd configure your data source according to the SQL Server docs - http://technet.microsoft.com/en-us/library/bb879949%28v=sql.110%29.aspx