For a data source to be able to support incremental updates, it needs to be a structured, relational database and it needs: a primary key column that uniquely identifies records
For a data source to be able to support incremental updates, it needs to be a structured, relational database and it needs: a primary key column that uniquely identifies records
To determine which data source to use, you first need to consider where your data is stored. Depending on where your data is stored, you have different ways of connecting
Today’s post combines the topics of the previous two posts and moves into Power Query to connect to SQL directly instead of connecting to static, exported SmartLists or flat files.
Today’s post is combining the topics of the previous two posts and moving into Power Query to connect to SQL directly instead of connecting to static, exported SmartLists or flat
We’ve recently upgraded a client from SmartConnect 2018 to SmartConnect 2021 and mosstly had no problems. One issue which came up is when users tried to run an integration which