Data Pipeline Differentiator

In this episode, Bob Collie – Chief Technology Advisor at Zmclp & Board Member at IT Renew, shared how the IT Renew team built a Financial and Customer Hub in minutes for Business Central 365, Salesforce & Azure SQL Warehouse.

Key Highlights

  • How Lyftrondata is enabling the creation of pipelines from Business Central 365, Salesforce, and Azure SQL Warehouse in the future
  • Utilizing Lyftrondata virtualization, accelerate analytics with Tableau by quickly analyzing data from Business Central 365, Salesforce, and Azure SQL Warehouse.
  • How data from Salesforce & Business Central 365 may be easily analyzed through an ANSI SQL layer.
  • Improving ROI on the current modern data stack.
  • Secrets to execute high-performance transformations reliably.


Microsoft Dynamics 365 Business Central is a cloud-based, all-in-one business management solution which enables customers to upgrade from their entry-level accounting software or legacy ERP system to one single, comprehensive solution to manage finances, operations, sales, and customer service.

Salesforce is a famous American cloud-based software company that provides CRM services. Salesforce is a popular CRM tool for support, sales, and marketing teams worldwide. Salesforce services allow businesses to use cloud technology to better connect with partners, customers, and potential customers.

A managed Data Warehouse-as-a Service (DWaaS) offering provided by Microsoft Azure is known as Azure SQL Warehouse. Data Warehouse means federated storage for data compiled by the active networks. Data systems intensify the collecting of data from varied derivations for both access and analysis.

Data Stack is a part of a computer in which a summarized data type serves as an anthology of components, with two major primary operations: Push and Pop. In which adds an element to the collection is Push, and Pop means removal of a recently added element that was not yet eliminated.

ROI stands for Return on Investment. Which is the ratio between income and investment. It is used to evaluate the efficiency of investment concerning income.

Tableau is the platform that helps people to understand the virtual analytics of data transformation. It is a tool used by organizations for business intelligence and data analytics.

It is an analytics tool that helps in analyzing big data, data integration, and data warehousing. Azure Synapse is known for its limitless analytical capabilities. It offers dedicated and serverless potential to query limitless data at your terms.

The steps for replicating Dynamic 365 Business Central to Snowflake are as follows:

Prerequisite: navigate to the connection tab

  • Step 1: Tap on Add Connection.
  • Step 2: Choose Snowflake as your destination.
  • Step 3: Tap on the test connection to see that the configuration is fine.
  • Step 4: Save Changes.

The process of Moving data from Salesforce to Snowflake is given below:

  • Step 1: Make an account and log in to Salesforce API
  • Step 2: Select the create job tab.
  • Step 3: Click on the batch and add that to the Job.
  • Step 4: Check the status of the Batch
  • Step 5: Fetch the results.
  • Step 6: Close the Job Tab.
  • Step 7: Load Data to Snowflake from Salesforce.
  • Step 8: Create Snowflake Stage
  • Step 9: Create a Snowflake file format
  • Step 10: Load Salesforce JSON to Snowflake
  • Step 11: Parsing JSON file In Snowflake

The process of normalizing business central 365 data are as follows:

  • Go to Settings > Solutions > Packt.
  • Tab on New Entity.
  • Enter Details
  • Go to Forms and double-click the Quick View Form Tab.
  • Untick all the checkboxes on the form before saving the new entity
  • Do dragging and dropping two attributes from the right-hand Field Explore on the form click on Save and Close.
  • Save and go back to the dashboard
  • Navigate to Entities
  • Enter Details in the primary contact field and click on Save.
  • Navigate to the contact's Forms and double-click the Main Information form.
  • Add a new field by dragging and dropping the attribute from the right-hand window on to the form.
  • Click on the Insert tab at the top followed by Quick View Form
  • Enter the following details in the Quick View Control Properties window
  • Tap on OKAY
  • Save and Close the tab
  • Click on the Publish All Customizations button for your solution.

Structure Query Language Server is an RDBMS, which broadly means Relational Database Management System. It helps in the management for business intelligence, application analytics and transaction processing.

Lyftrondata is a data fabric platform that offers modern data cloud warehousing. It eliminates the manual building of a data pipeline and automates the instant creation of data for insights. Lyftrondata helps in differentiating data pipelines using modern data architecture.

Lyftrondata is a modern data warehousing platform that helps Business Central 365, Azure SQL Warehouse, and Salesforce for automating data pipelines. Using Lyftrondata's architecture you can effortlessly accelerate of cloud and expansion of analytical capabilities of Tableau.

About Coffee With Data

Listen, Engage and Learn from Data Scientists and Big Data Thought Leaders.


The Coffee with Data podcast series is for data and business leaders to learn how they leverage the cloud to unite, share, and analyze data to drive business growth, fuel innovation, and disrupt their industries. The data topic covered shall empower our future guests and our engaging audiences – Data Governance, Data Management, Data Science, Data Quality, Data Strategy, Data Architecture, Data Analytics, Machine Learning, Artificial Intelligence, Data Security and Privacy, Master Data Management are to name a few.

Host | George Firican & Diana Firican
Founders at LightsOnData
Speaker | Bob Collie
Chief Technology Advisor at Zmclp & Board Member at IT Renew

Previous Episodes

For further questions, email us at

Be our guest. Inspire other thought leaders out there.

Be Our Guest