375 docs tagged with "data sync"

How to connect to .NET XML DataSet format XML files in Data Sync.

How to troubleshoot errors to do with 32 bit drivers

What is the Run Tool.

What Calculated Columns are within Data Synchronisation Studio

What is the connection library and how to update existing connections

What data sources are in Data Synchronisation Studio.

How to use lookups in Data Sync.

How you can use Project Automation to run your own code in Data Sync.

What the schema map is in Data Sync

How you can use the SQL query tool to run SQL statements against your databases

Details on the function ABS

How to create an ACS app in SharePoint so then you can connect via Data Sync using OAuth.

Details on how to activate the license key within Data Sync and Ouvvi

The connection guides and how to guides for Connecting to Active Directory in Data Sync.

How to add Steps in the Run Tool.

Details on the function ADD

How to add additional Active Directory attributes to your schema in Data Sync to include in your integration

How to add an additional data source to the API Connection file using the Data Sync JSON API Tool.

How to use the ADO.NET connector in Data Sync.

How to connect to Amazon S3 buckets using Data Sync.

How to apply grouping and aggregate functions to a Data Sync dataset.

Details on the function AND

Details on the function ARRAYINDEX

Details on the function ARRAYLEN

How to use Data Sync to download the full Dynamics 365 Audit History including the change details.

How to add authentication to connect to the API in the Data Sync JSON API Tool.

How to connect to Dynamics 365 via OAuth using a custom Azure AD application in Data Sync and the authorization_code flow.

Details on the function AVERAGE

The connection guides and how to guides for Connecting to Azure Items in Data Sync.

The best practices to follow when using the Run Tool.

Details on the function BITWISEAND

Details on the function BITWISECOMPLEMENT

Details on the function BITWISEOR

Details on the function BITWISEXOR

How to Azure Blob Storage using Data Sync.

Using Data Sync to update large numbers of records in Active Directory.

How to use Data Sync to upload documents to a Document Library from a single Excel Spreadsheet

Details on the function BYTE

How to use CAML Queries to filter SharePoint lists and libraries in Data Sync

Details on the function CASE

How to use Data Sync to roll up contacts linked to a campaign in Dynamics 365 marketing lists

Details on the function CEILING

How to change the connection library path so that you can use a different connection library in your projects

How to use project automation to write the compare results of a Data Sync project to an XML file if it is run from the Run Tool.

How to add Change Tracking to a SQL table with Data Sync

How to check in and check out documents to SharePoint from Data Sync when adding and updating documents

Details on the function CHOOSE

How to connect to SharePoint using the Client API connector in Data Sync.

How to connect to Dynamics 365 via OAuth using a custom Azure AD application in Data Sync and the client_credentials flow.

Command LIne options available for running your Run Tool and Data Sync projects.

Details on the function COMPARE

Details on the function COMPUTERNAME

How to manage Active Directory Computer records using Data Sync.

Details on the function CONCAT

Details on the function CONCATENATE

The core concepts of using Data Synchronisation Studio

How to connect to Ouvvi from Data Synchronisation Studio and open a Data Sync step stored in the Ouvvi database.

How to connect an API Datasource to the source or target window from the JSON API Tool.

Understanding Connection Properties and how to use them

How to use Data Sync to roll up contacts linked to a campaign in Dynamics 365 marketing lists

How to manage contacts in Active Directory using Data Sync.

How to copy Steps in the Run Tool.

How to copy the address details for a contact from the account entity

How you can create a new database using the SQL query tool found within Data Sync.

How to automatically gather the Schema details from a JSON File using the Data Sync JSON API Tool.

How to automatically gather the API connection details from a URL using the Data Sync JSON API Tool.

How to create user accounts and set a password in Active Directory using Data Sync

How to add and configure the Create a Text File Step in the Run Tool.

How to describe and design the API connection details manually in the Data Sync JSON API Tool, including examples.

How to create Dynamics Activity records using Data Sync

How to add documents into folders with their metadata in SharePoint document libraries using a file directory as a template

How to connect to CSV files in Data Sync.

Details on the function CURRENCY

How to create a custom entity in Dynamics 365 and add data from a SQL database.

How to connect to SharePoint Online using the custom OAuth connection Data Sync.

How to connect to SharePoint Online using the custom OAuth connection with Certificate in Data Sync.

How to use the Data Generator connector in Data Sync.

How to use another data sync project as a datasource in Data Sync.

The configuration settings needed for the Data Sync Project step.

How to add a Data Sync Step to your Run Tool projects.

How to use the DataTableTransform function in the Data Sync JSON API Tool.

The documentation introduction for all database connectors.

Details on the function DATALENGTH

What is a datasource and how can you connect to one in the JSON API Tool in Data Sync

Details on the function DATEADD

Details on the function DATEDIFF

Details on the function DATESTR

Details on the function DATETIME

Details on the function DATEVALUE

Details on the function DAY

How to use the Database Schema Sync Connector in Data Sync.

Details on the function DECIMAL

How to connect to Dynamics 365 using the default connection Data Sync.

How to delete Steps in the Run Tool.

How to add and configure the Delete Folder Step in the Run Tool.

How to delete records from a SQL table with Data Sync

What is the difference between Data Synchronisation Studio Version 6 and Version 3.

Details on the function DIVIDE

Details on the function DOMAINNAME

What are DSCACHE files and how to change the default location.

How to use the duplicate removal connector to remove duplicated data in Data Sync.

How to use dynamic columns in Data Sync.

Dynamics connection documentation introduction.

How to edit Steps in the Run Tool.

How to edit/update existing connections

How you can use the SQL query tool to edit records in your table.

How to edit lookups in Data Sync.

How to edit the schedule of your Run Tool projects in Windows Task Scheduler.

How the Empty Data Source Connector can be used in Data Sync.

Details on the function EMPTYGUID

How to set the useraccountcontrol attribute to enable and disable Active Directory users with Data Sync

How to add encryption to your Data Sync projects.

Details on the function ENDSWITH

Details on the function EQUALS

How to handle and understand errors, including how to determine what is the root cause.

How to get and activate an evaluation of Data Synchronisation Studio

How to connect to Excel XLSX files in Data Sync.

How to add and configure the Execute SQL Step in the Run Tool.

How to move Data Sync and Ouvvi to a new Server using the existing database

How to export Data Synchronisation Studio's change set data (compare results) into an XML file

How to export the preview data from Data Sync

How to export data from Salesforce into a new CSV file using Data Sync

How to export SharePoint lists into new and existing SQL tables using Data Sync

How to export data from a Salesforce Objects into a new SQL Table using Data Sync

How to set the useraccountcontrol attribute to enable and disable Active Directory users with Data Sync

How to add and configure the Run External Program Step in the Run Tool.

Details on the function FALSE

How to connect and use the Dynamics FetchXML connector in Data Sync.

How to add and configure the Copy File Step in the Run Tool.

How to connect to a file in a SharePoint list and use the data within that file.

How to add and configure the Delete File Step in the Run Tool.

File System connection documentation introduction.

Details on the function FILEDATA

Details on the function FILEEXTENSION

Details on the function FILENAME

Details on the function FILENAMEWITHOUTEXTENSION

Details on the function FILEPATH

How to connect to file systems in Data Sync.

Details on the function FILETEXT

How to set the useraccountcontrol attribute to enable and disable Active Directory users with Data Sync

How to filter your data from the data source window in Data Sync Studio.

A walkthrough project to help you get started with Data Synchronisation Studio

Details on the function FLOOR

How to use the For Each function in the Data Sync JSON API Tool.

Details on the function FORMAT

Details on the function FROM

Details on the function FROMBASE64

Details on the function FROMCSV

Details on the function FROMDATASYNC

Details on the function FROMEXCEL

Details on the function FROMEXCELOPENXML

Details on the function FROMFILETIME

Details on the function FROMFILETIMEUTC

How to read data from Google Sheets using Data Sync.

How to connect to Azure AD and Office Applications using Graph API with Data Sync.

How to use the Project Grouping connector in Data Sync.

How to add users to Active Directory Groups using Data Sync.

Details on the function GUID

Details on the function HOUR

How to add a step to download a file via HTTP(s) in the Run Tool.

How to add a step to upload a file via HTTP(s) in the Run Tool.

Details on the function IF

How to import an existing Data Sync step into the Run Tool.

How to add and configure the Import Command Line Parameter Step in the Run Tool.

How to use Data Synchronisation Studio to import data from a CSV file to an XML file

How to import documents as attachments in Dynamics using Data Sync

How to add and configure the Import Environment Variable Step in the Run Tool.

How to use Data Synchronisation Studio to import multiple XML files

How to use Data Sync to easily Import SQL Table to a SharePoint List

How to use Data Synchronisation Studio to import data into a new SQL Table

How to use incremental sync mode in Data Sync.

How to troubleshoot errors to do with 32 bit drivers

Details on the function INSTR

Details on the function INT

How to sync data to Navision using Data Sync

How to use Data Sync to import and export data to and from Salesforce

How the comparison in Data Sync works and can be used.

Getting Started with Data Synchronisation Studio

What is Data Synchronisation Studio

Details on the function ISDUPLICATE

Details on the function ISEVEN

Details on the function ISINT

Details on the function ISLONG

Details on the function ISNOTNULL

Details on the function ISNULL

Details on the function ISNULLOREMPTY

Details on the function ISNULLORWHITESPACE

Details on the function ISNUMBER

Details on the function ISO8601DATE

Details on the function ISO8601DATETIME

Details on the function ISODD

How you can use item events within project automation in Data Sync.

Details on the function JOIN

Details on the function JSELECTTOKEN

How to use the JSON API Connector .

How to use the JSON API Designer to build the XML document needed for the connector.

Details on the function KV

Using LDAP Paths and Filters with the Active Directory Connector in Data Sync

Details on the function LEFT

How to connect to Dynamics 365 using legacy authentication in Data Sync.

How to connect to SharePoint Online using a username and password (legacy authentication).

Details on the function LEN

Details on the function LENGTH

How to get list item attachments from SharePoint

How to automatically copy items from one SharePoint site to another when an item is changed in a SharePoint List using Data Sync and Ouvvi

How to troubleshoot local host issues when using Data Sync when HSTS is enabled

How to add and configure the Log Entry Step in the Run Tool.

How to access the Run Tool logs and figure out what the error is.

Details on the function LONG

How to use Data Sync to set Content Types on SharePoint list items during an integration

Details on the function LOOKUPA

Details on the function LOOKUPAINCREMENTAL

Details on the function LOOKUPB

Details on the function LOOKUPBINCREMENTAL

Details on the function LOOKUPEX

How to use lookups to look up values in different OUs in your Active Directory in Data Sync

How to use lookups to get data from other entities in Dynamics

How to use Data Sync to lookup values in Salesforce

How to use lookups with SharePoint in Data Synchronisation Studio

Details on the function LOWER

Details on the function LTRIM

Adding and updating groups and group membership in Active Directory using Data Sync

Details on the function MD5HASH

Details on the function MID

How to migrate from Dynamics On-Premise to Dynamics Online using Data Sync

Details on the function MILLISECOND

Details on the function MINUTE

Details on the function MOD

How to download and install the Mongo DB connector in Data Sync.

Details on the function MONTH

How to move objects/items to different OU's in your Active Directory using Data Sync

How to move the existing Ouvvi Database to a new machine.

Details on how to move the license key for Data Sync and Ouvvi

Details on the function MULTIPLY

How to install and use the MySQL connector in Data Sync.

How you can connect to MariaDB using the SQL query tool found within Data Sync.

How to connect and use the Dynamics N:N connector to use Dynamics Relationships in Data Sync.

How to define Dynamics 365 many to many (n:n) relationships

How to connect to Dynamics Navision with Data Sync.

Details on the function NETWORKDAYS

How to move Data Sync and Ouvvi to a new Server

Details on the function NEWGUID

Details on the function NEWLINE

Details on the function NEXTINT

Details on the function NOT

Details on the function NOW

Details on the function NULL

Details on the function NUMBER

Details on the function OBFUSCATE

The OData connection documentation introduction.

How to use the OData 2.0 connector in Data Sync.

How to use the OData 4.0 connector in Data Sync.

How to connect to databases using the ODBC connector in Data Sync.

How to manually activate your Data Sync if you do not have an internet connection

How to connect to databases using the OleDB connector in Data Sync.

How to connect to Dynamics On Premise in Data Sync.

How to connect to SharePoint Online using the default connection Data Sync.

How to open and edit an API XML File in the JSON API Tool.

How to open a Data Synchronisation Studio project from your Ouvvi site.

How to connect to Dynamics 365 Optionsets

Details on the function OR

How to install and use the Oracle connector in Data Sync.

How to create a project schedule in Ouvvi to run your Run Tool and Data Sync projects.

How to connect to an Ouvvi App as a datasource in Data Sync.

How to connect to a Simego Changeset data file in Data Sync.

How to add and configure the Ouvvi Project Step in the Run Tool.

How to pass Ouvvi user settings into Data Sync to be used in your projects.

How to move Data Sync and Ouvvi to a new Server

Details on the function PADLEFT

Details on the function PADRIGHT

How to define Parameters in the Data Sync JSON API Tool.

How to download and install the Podio connector in Data Sync.

How to install and use the PostgreSQL connector in Data Sync.

How you can connect to a PostgreSQL Database using the SQL query tool.

How to add and configure the Run External Program Step in the Run Tool to run a Powershell Script in your Run Tool sequence.

How to preview data in Data Sync

How to diagnose and identify problematic data issues.

What is a Data Sync project, how to open a project from Ouvvi and how to edit the project properties.

How you can use Project Automation to run your own code in Data Sync. The following pages will help guide you with examples of how to write useful expressions to achieve the results you want.

How to view and edit project properties in Data Synchronisation Studio.

How to add and configure the Project Status Email Report Step in the Run Tool.

Details on the function PROPER

Details on the function PROPERTY

How to configure Data Sync and Ouvvi to use your Proxy Server.

How to add and configure the Run External Program Step in the Run Tool to run a Python Script in your Run Tool sequence.

All the release notes for Data Sync and Ouvvi from 2023

Details on the function REPLACE

Details on the function REPLACEREGEX

How to use REST API's within Data Sync.

Details on the function RIGHT

Details on the function RND

Details on the function RNDDOUBLE

Details on the function ROUND

How to connect to RSS XML files or RSS Feeds in Data Sync.

Details on the function RTFTOPLAINTEXT

Details on the function RTRIM

How to change the run condition of steps in the Run Tool.

The configuration settings needed for the Run Tool step.

How to run steps in the Run Tool. Including how to run a single step, the whole project and selected steps.

How to use the Salesforce connector in Data Sync.

How to add and configure the Save Project Step in the Run Tool.

How to schedule a Data Sync project to run unattended.

The options available to schedule your Run Tool projects.

Different ways to get the schema information from an API in the Data Sync JSON API Tool.

The schema map column properties available in Data Sync

How to use the SQL Script Tool in the Data Sync Schema Map window to generate script to create a table and execute it

Details on the function SEARCH

Details on the function SECOND

How you can use the SQL query tool to select data from a table.

How to add and configure the Send Email Step in the Run Tool.

How to use Data Sync to set Content Types on SharePoint list items during an integration

How to use Data Sync to set records in Dynamics Entities to inactive rather than deleting them

How to set the password for Active Directory users using Data Sync.

How to add and configure the Set Process Environment Variable Step in the Run Tool.

Details on the function SETTINGA

Details on the function SETTINGB

How to install the WinSCP connector in Data Sync to connect to SFTP and FTP servers.

Details on the function SHA1HASH

SharePoint connection documentation introduction.

The connection documentation introduction for the Simego specific connectors.

How to add SMTP settings to a Run Tool project to enable sending email steps.

How to connect to Salesforce using the SOQL provider in Data Sync

How to add your Run Tool project to source control (git).

Details on the function SPLIT

How to configure SQL agent to run a Data Sync project

The SQL Scripting Tool and how to use it

How to use the SQL Server OleDB connector in Data Sync to connect to a SQL database.

How to use the SQL Server SQLClient connector in Data Sync to connect to a SQL database.

Details on the function SQRT

Details on the function STARTSWITH

How to use the Static Data Source connector in Data Sync.

What are Steps in the Run Tool.

Details on the function STR

Details on the function SUBSTR

Details on the function SUBTRACT

Details on the function SUM

How to copy Documents from a SharePoint Document Library to a Local Folder on your computer

Using Data Sync to update and import documents and metadata columns to a SharePoint Document Library

A few Sync Optimisations you can do in Data Sync to improve your Dynamics integration speeds

Use Data Sync to synchronise Active Directory users with SharePoint lists to create an employee directory or contact list

How to Azure Table Storage using Data Sync.

How to schedule your Run Tool projects using Windows Task Scheduler.

The connection guides for Connecting to text files and CSV files in Data Sync.

How to connect to Text files in Data Sync.

How to add and configure the Tome Delay Step in the Run Tool.

Details on the function TIMESTR

Details on the function TOARRAYSTRING

Details on the function TOBASE64

Details on the function TOBYTEARRAY

Details on the function TOBYTEARRAYASCII

Details on the function TOBYTEARRAYUNICODE

Details on the function TOBYTEARRAYUTF8

Details on the function TODAY

Details on the function TOSID

Details on the function TRIM

Details on the function TRUE

How to update the manager attribute in Active Directory using Data Sync

How to set the useraccountcontrol attribute to enable and disable Active Directory users with Data Sync

How to upgrade from Data Sync V3 to Data Sync V6, and some considerations.

Details on the function UPPER

What User Settings are, how to create them and how to use them in your Run Tool projects.

Details on the function USERNAME

How to connect to Active Directory to update user accounts and add new users using Data Sync.

Details on the function UTCNOW

How to read and save simple values to a persistent backing store (values store).

How to add and configure the Version Number Increment Step in the Run Tool.

Details on the function WEEKDAY

Details on the function WEEKNUM

Details on the function WHEN

How to write back to an API using the JSON API Tool and Project Automation in Data Sync

The connection guides for Connecting to XML Datasets in Data Sync.

How to connect to XML files in Data Sync.

Details on the function YEAR

How to connect to and extract files from a Zip folder using the Zip archive connector in Data Sync.

How to add and configure the Run External Program Step in the Run Tool to Zip a File using TAR.exe in your Run Tool sequence.