Configuring the Adapter

The adapter software is already installed as part of the normal installation of Tidal Automation.

To license and configure the adapter before you can run Microsoft SQL jobs, perform these steps:

• Defining a Microsoft SQL Security Policy – Create a security policy to assign to the users that will run Microsoft SQL jobs. You may want to create different security policies to differentiate between users who just run Microsoft SQL jobs versus users who can run and edit Microsoft SQL jobs.

• Licensing an Adapter – License the connection(s) to the Microsoft SQL instance. You cannot define a Microsoft SQL connection until you have applied the Microsoft SQL license.

• Securing the Microsoft SQL Database Adapter – Create one or more user definitions in Tidal Automation with access to the Microsoft SQL instance using Microsoft SQL user names and passwords provided by the Microsoft SQL administrator. Users in Tidal Automation are authorized to run Microsoft SQL jobs on behalf of these Microsoft SQL runtime users.

• Define a Microsoft SQL Connection – Define a Microsoft SQL connection so the master can communicate with the Microsoft SQL instance.

See also Configuring service.props for information about general and adapter-specific properties that can be set to control things like logging and connection properties.