Synchronizing UB Errors to MS SQL table

Read the following topic to understand how to synchronize the UB Errors to MS SQL table.

About this task

Complete the following tasks to synchronize the UB Errors to MS SQL table.

1. Log in to Scribe Online.
2. Go to Connections and click New to create new connection.
3. Choose Microsoft SQL Server connector type from the list.
4. Click Test Connection.
5. Click OK.
6. Use on the premise agent that is installed in the same network as your MS SQL Server.
7. Create a new advanced map with Acoustic Campaign connection as a source and the SQL connection, created above, as the target.
8. Complete the following steps to add a Query control block.
   1. Configure the following settings on the General tab:
      1. Label: Type the Query block from the source connection, for example 'Query UBErrors'.
      2. Entity: Select UBErrors.
   2. Save the query.
9. Complete the following steps to add a control block for each result to iterate over the retrieved records.
   1. Configure the following settings on the General tab:
      1. Label: Type the Create block from the target connection, for example 'Create UBError'.
      2. Entity: Select UBError from the MS SQL instance.
   2. Click the Fields tab and map the fields.
   3. Click OK to save the block.