Automate import utilities through jobs

Products

• Information Centric Analytics

Issue/Introduction

Some data source integrations rely on an import utility to periodically query a source data system. You can use the SQL Server Agent to create jobs that will execute these import utilities on a schedule of your choosing.

Environment

Version : 6.x

Resolution

This procedure refers to the Symantec Cloud SWG Import Utility (formerly the Symantec WSS Import Utility) but is representative of the process you would follow for any other integration that relies on a command line executable to query its data source.

You will first create the credential used by the proxy that will run the executable. Next, you will create the proxy under which the job will run. Finally, you will create and schedule the job itself.

Credential

1. Open SQL Server Management Studio (SSMS)
2. In Object Explorer, navigate to Security > Credentials
3. Right-click the Credentials folder and select New Credential...
   The New Credential window opens
4. In the Credential name field, type: Symantec CloudSWG Importer Credential
5. In the Identity field, type the name of the ICA service account or another account with sufficient privileges on the file system to execute the Cloud SWG Import Utility
6. Type and confirm the password for the account you typed in the Identity field
7. Click the OK button to close the New Credential window

Proxy

1. In Object Explorer, navigate to SQL Server Agent > Proxies > Operating System (CmdExec)
2. Right-click the Operating System (CmdExec) folder and select New Proxy...
   The New Proxy Account window opens
3. In the Proxy name field, type: RiskFabric SymantecCloudSWG Proxy
4. In the Credential name field, type: Symantec CloudSWG Importer Credential
5. Click the OK button to close the New Proxy Account window

Job

1. In Object Explorer, navigate to SQL Server Agent > Jobs
2. Right-click the Jobs folder and select New Job...
   The New Job window opens
3. On the General page in the Name field, type: RiskFabric SymantecCloudSWG Import
4. Select the Steps page
5. Click the New... button
   The New Job Step window opens
6. On the General page in the Step name field, type: Data Import
7. From the Type dropdown menu, select Operating system (CmdExec)
8. From the Run as dropdown, select the RiskFabric SymantecCloudSWG Proxy
9. In the Command window, provide the full path and executable name for the Symantec Cloud SWG Import Utility enclosed in double-quotation marks
   Example:
   "C:\Program Files\Bay Dynamics\Database Utilities\SymantecCloudSWG\SymantecCloudSWGImporter.exe"
10. Click the OK button to close the New Job Step window
11. In the New Job window, select the Schedules page
12. Click the New... button
    The New Job Schedule window opens
13. Configure the job schedule to run on days and times that do not overlap with the nightly RiskFabric Processing job and the RiskFabric Intraday Processing job
14. Click the OK button to close the New Job Schedule window
15. Click the OK button to close the New Job window