We are working hard to make updates to the Shop and Account Management portal.

Please note that many of these changes will roll out this Saturday, June 1st and will require downtime. We are working to ensure minimal disruption for our eOne community and really appreciate your patience as we push out these changes. Please reach out to sales@eonesolutions.com with any questions.

Creating a SQL Server Change Data Source

Creating a SQL Server Change Data Source

  1. From the main Navigation Menu, select Data Sources>>Change Triggers>>Trigger.
  2. On the Change Triggers page, click the Create Change Trigger Button.
  3. On the New Change Trigger page, click MSSQL Table Change Data Source.
  4. The page to configure the MSSQL Change Data Source opens.

SQL Change Window

  1. Enter a Description for the MSSQL Table Change Data Source.
  2. Connection – Select the MSSQL connection to be used from the dropdown list.
  3. Click Validate. If the connection is successful, the Database field becomes active.
  4. Database – Select the SQL database the query data source will be using.
  5. Table – Select the table the change source will be looking at for changes. ct a Table to track changed records.
  6. Click Save.
  7. Click Edit Query to launch the query builder.
  8. By default, the chosen table from step 7 and the tracking table generated by SmartConnect will automatically be loaded with all columns selected. Any modification to the query can be done at this time. See query builder use here. Needs to link to article on query builder.
  9. Click Save Query.
  10. Click Validate.
  11. Click Save.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

Reset Filters