Data Warehouses

Migrating from Postgres to Amazon Redshift

Oct 29, 2021 By Abe Dearmer In Integrate

Migrating from Heroku Postgres to Amazon Redshift might sound complicated, but moving data between these two systems is easier than you think. You might need to transfer data from Postgres to Redshift for all kinds of reasons. Here are two of the most common.

Read Post

Integrate

Read more about Migrating from Postgres to Amazon Redshift

5 Tips for Pushing Data from Your Warehouse to Salesforce

Oct 19, 2021 By Mark Smallcombe In Integrate

Salesforce is the most popular CRM (customer relationship management) platform in the world. As last count, the Salesforce CRM enjoyed a 20 percent market share, with more than 150,000 companies among its customers. One of Salesforce’s best features is its ability to run business intelligence (BI) and analytics workloads to identify hidden trends and insights and make smarter decisions for your sales, marketing, and customer support teams.

Read Post

Integrate

Read more about 5 Tips for Pushing Data from Your Warehouse to Salesforce

5 Tips for Pushing Data from Your Warehouse to Marketo

Oct 11, 2021 By Mark Smallcombe In Integrate

Nurturing your customer prospects is a crucial task to increase your conversion rates—so how can you make sure that valuable leads don’t fall through the cracks? That’s exactly where software like Marketo comes in. Marketo is a marketing automation tool to help standardize and automate your marketing funnel, helping push your prospects along the buyer’s journey from awareness to acquisition.

Read Post

Integrate

Read more about 5 Tips for Pushing Data from Your Warehouse to Marketo

The Data Chief Live: Beyond the Buzz in Data Mesh, Lakehouse, Data Warehouse

Oct 7, 2021 By ThoughtSpot In ThoughtSpot

Join The Data Chief Live on October 7 to go beyond the buzz on all things data mesh, lakehouse, and data warehouse. Gain clarity on what is hype, what is real, and how others are delivering business value faster with modern data platforms and processes. You'll hear live from Darren Pedroza, VP Enterprise Data and Analytics, First Command Financial Services, Inc., Zhamak Dehghani, Director of Emerging Technologies at Thoughtworks & author of The Data Mesh, Chris D'Agostino, Global Field CTO Databricks & me.

View Video

ThoughtSpot

Read more about The Data Chief Live: Beyond the Buzz in Data Mesh, Lakehouse, Data Warehouse

Data lakes vs. data warehouses

Oct 5, 2021 By Charles Wang In Fivetran

Successful analytics depends on choosing the right approach to storing your enterprise data.

Read Post

Fivetran

Read more about Data lakes vs. data warehouses

5 Tips for Pushing Data From Your Warehouse to Zendesk

Oct 4, 2021 By Abe Dearmer In Integrate

For decades, ETL (extract, transform, load) has been a mainstay of organizations’ data integration workflows, moving information from various sources to a centralized data warehouse. More recently, however, businesses have been shaking things up with reverse ETL, which flips the sources and targets by sending data from your warehouse to third-party systems like Zendesk.

Read Post

Integrate

Read more about 5 Tips for Pushing Data From Your Warehouse to Zendesk

Apache Hive vs. Apache HBase

Sep 24, 2021 By Mark Smallcombe In Integrate

Apache Hive and Apache HBase are incredible tools for Big Data. While there is some overlap in their functions, both Apache Hive and Apache HBase have unique qualities that make them better suited to specific tasks. Some key differences include: Ultimately, comparing Apache Hive to Apache HBase is like comparing apples to oranges or Google to Facebook. While the two entities are similar, they don't provide users with the same functionality.

Read Post

Integrate

Read more about Apache Hive vs. Apache HBase

Pushing Data to Zendesk From Your Warehouse

Sep 17, 2021 By Abe Dearmer In Integrate

Data warehouses have made it easier for customers to store massive amounts of data. That information is useless, however, unless it is actionable. Making data actionable means employees can use the data for decision-making and improving the user experience. In this article, we’ll discuss reverse ETL, pushing data to Zendesk from your warehouse, and the value of this process.

Read Post

Integrate

Read more about Pushing Data to Zendesk From Your Warehouse

Which Tables in a Data Warehouse Use Change Data Capture

Sep 15, 2021 By Mark Smallcombe In Integrate

In today’s 24/7 digital world, real-time data is a necessity to stay relevant for today’s businesses. Companies who wish to remain competitive must be able to quickly respond to customer demand and adjust to market changes. Supplying business leaders with real-time information for informed decision-making can be a challenge with information spread among disparate systems.

Read Post

Integrate

Read more about Which Tables in a Data Warehouse Use Change Data Capture

5 Tips for Pushing Data from Your Warehouse to NetSuite

Sep 14, 2021 By Abe Dearmer In Integrate

NetSuite is an enterprise resource planning (ERP) business management platform part of the Oracle enterprise software ecosystem. Although it's primarily intended for small and medium-sized businesses, organizations of all sizes and industries have successfully used NetSuite to balance their checkbooks, manage inventory, bill and invoice customers, and more.

Read Post