Copy data from the results of a SQL query to a target repository by generating a SQL export file using the specified query and then importing the data into the target repository using the designated import template. This BIC would typically be used when moving data from a request repository to the actual data repository.
Inputs
- sql_query - Defines the SQL query to execute against the Enable database. Work item properties can be referenced by surrounding them with percent signs. NOTE: To use percent signs in the actual SQL query (e.g., wildcard in LIKE statement), precede each with a backslash character. For example: WHERE myColumn LIKE '\%something\%'. If referencing a work item property and the value may contain single quotes, surround the property reference with curly braces to ensure any single quotes are escaped. For example: WHERE myColumn LIKE '{%myProperty%}'. The curly braces must be inside the single quotes AND the property value cannot have any curly braces itself.
- sourceDirectoryName - Fully qualified path to directory where source file is to be placed.
- sourceFileName - Base name for source file (timestamp and extension will be added to the name)
- targetRepoName - The target repository name
- targetRepoImportTemplateName - The import template name of the target repository
- keepRepoValues - Retain repository values if value in file is empty if Yes;
- validateAfterCopy - Validate the records after they have been copied if Yes (default is No)
Outputs
- repoDataCopyStatus - Results of email send operation (SUCCESS or FAIL)
- repoDataCopyMessage - Detailed error message if email.send.status is FAIL
- sql_num_rows - Number of rows returned by the SQL query