You might get the following error while trying to connect, test, or add SQL test statements using AtriumIntegrator with Spoon:

org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database

Error connecting to database: (using class com.microsoft.sqlserver.jdbc.SQLServerDriver)
The property integratedSecurity does not contain a valid boolean value. Only true or false can be used.

Legacy ID:KA427151

The reason for this is not very intuitive and we did not find this documented anywhere. The root cause is that one of the required parameters gets excluded during the first initial creation of the connection: 

Under Options it is indeed missing:

The fix for this is to just add the missing "integratedSecurity" to the list and add a value. In this case I added "false".

Conversely a value of "true" would mean that Windows Authentication is used instead.

NOTE: You may need to do this for every existing connection associated with this Connection. We've noticed that changing it in one Transformation does not propagate the setting to all others. Exporting the job to an XML would also show where the setting needs to be updated. More information on how to set jdbc client for SQLServer can be found on Microsoft website:

https://msdn.microsoft.com/en-us/library/ms378428(v=sql.90).aspx#Connectingintegrated

BMC provides AtriumCore connectivity to ARServer and use of Spoon is the additional benefit, however specific configuration for data vendor should be provided by the database vendor.
For example MSSQL would not be able to provide information on how to connect to AR Server. These are proprietary configuration items that can investigate with the vendor and we will try to do that, but this is not something we can adhere to as a "Spoon" or Atrium Integrator defect. We sincerely hope that you allow us to present this position and apologize for the inconvenience this is causing.