Azure SQL to Salesforce Upsert
Created by Chris Ward, SnapLogic This pattern connects to an Azure SQL database to perform a query data and then Upserts the results to an object in Salesforce. Both error and successful records are written to a log file within SLDB. The pattern could be used to migrate customer data stored in a transactional Azure SQL table into Salesforce for Sales prospecting. Both Azure SQL & Salesforce accounts are required and the necessary mappings specified in the Mapper Snap. Configuration Sources: Azure SQL Table Targets: Any Salesforce Object Snaps used: Azure SQL Execute, Mapper, Salesforce Upsert, JSON Formatter, File Writer Downloads Azure SQL to Salesforce Upsert.slp (12.9 KB)
SQL Server to Azure SQL Data Migration Pattern
Created by @asharifian, SnapLogic This pattern migrates table data from SQL Server and loads them to Azure SQL. Business case: SQL Server is the transactional database and encounter high data usage. Azure SQL is utilized for analytics and BI reporting. This use case is for a one-time data migration. Thereafter if necessary, a delta pipeline can be created by modifying these pipelines. Configuration Prerequisites: Tables can either be created on the fly, using the “Create table if not present” option in the Azure Bulk Load snap in the child pipeline or, if your tables have specific data type requirements, you can create the tables pior to executing the pipeline. You will need accounts for the Email Sender, Azure SQL, and SQL Server. Pipeline can accomodate the Azure SQL Dynamic account and SQL Server dynamic account, in case you want to have the integration be portable to handle differing databases. Sources: SQL Server Tables Targets: Azure SQL Tables Snaps used: JSON Generator, Pipeline Execute, Tail, Email Sender, Azure SQL - Execute, SQL Server - Execute, Azure SQL - Bulk Load Downloads SQL Server-Azure SQL-Data Migration.slp (8.9 KB) z_SQL Server-Azure SQL-Data Migration.slp (6.8 KB)
Error connecting to Azure SQL
Greetings, We are trying to connect to an Azure SQL database and we are getting the following errror… The port is 1433 because we checked in our DB properties… Screenshot_2020-05-20 17.52.42_ITXy5I|690x83 We have tried many different things so I am trying to see if there are any “gotchas” you may have to share Thank you Mitsos
Teradata to Cloud Data warehouse : Teradata to Azure SQL Data Warehouse
Teradata TPT FastExport Snap enables one to export large amounts of data out of Teradata very efficiently. On the target side if you are moving data into the Azure SQL Data warehouse, use the Azure polybase bulkload. If you were to move data to Redshift, then use the Redshift Bulkload Snap. Below is an example how you can configure the Teradata TPT fast export snap. The prerequisite is that you need to install the Teradata TPT utilities on every node of your Snaplex. Snaps Used: TPT FastExport, File Reader, CSV Formatter, CSV Formatter, Pipeline Execute, Azure Polybase Bulkload Download Teradata to Azure SQL Data Warehouse_2018_06_25.slp (10.0 KB) This pattern also calls the Pattern described in Reference Pipeline : To get schema details for a Teradata Table
