5 Must-Do Tasks to Prepare for Data Warehouse Migration

Businesses migrate their data warehouses for many reasons. Some are looking for improved performance around data loading, complex queries, and ELT. Others are focused on minimizing the cost of storage, reporting, and batch ELT processing. Sometimes it’s a combination of both these motivators, plus the need to reduce admin tasks and boost automation. Whatever the reasons may be, data warehouse migration can meet your desired goals when done correctly.

Continue reading...

Sales Creatio, How To

How to Call StarfishETL APIs from Creatio

August 26, 2022

If you are looking for a way to automate the push of data from Creatio CRM to another system using StarfishETL’s Designer (recently renamed Cloud Cartographer), you've come to the right place. We assume that you are already familiar with Creatio System Settings, Web Services, and Business…

Continue reading
StarfishETL api
Customer Service

Facilitating Sentiment Analysis with StarfishETL

August 17, 2022

Businesses looking to optimize their offerings and brand image turn to sentiment analysis to get it done. It’s applied by combining metrics and data from various touchpoints; and StarfishETL makes those connections possible by integrating data between all different types of applications. Here are a…

Continue reading
sentiment analysis
Data Integration

5 Ways to Reduce Data Integration Costs

July 28, 2022

Businesses looking to create these connected processes and streamline automation often integrate, but costs can rack up if the project has poor planning. In this post, we’ll highlight five ways to reduce data integration costs for more thoughtful and successful projects.

Continue reading
header image
Salesforce

Migrating Salesforce Legacy Attachments to Salesforce Files Using StarfishETL

July 25, 2022

If you are using Salesforce.com, you probably have made the transition to using the new Files functionality that uses ContentDocument objects. The old attachments functionality is often re-enabled so that the historical documents can still be made available. This approach is however not streamlined…

Continue reading
header image
Epicor Kinetic ERP

StarfishETL Epicor Connector & Integration Hints

July 11, 2022

I recently worked on a StarfishETL project to integrate a client’s Epicor ERP system with their Pipedrive Sales CRM software. Upon initial evaluation it seemed like a pretty straightforward project, but as work continued, I stumbled upon several issues that forced us to rethink our process and…

Continue reading
Epicor Integration Hints
iPaaS

Shortening the Sales Cycle Using iPaaS Integration

June 20, 2022

With an iPaaS providing flexible and scalable connections between business systems, sales cycles can be significantly reduced. The automation of contracts, quotes, and data analysis help eliminate many of the manual, administrative tasks that can clog up the sales process and distract reps from…

Continue reading
header image
Data Cleaning

[INFOGRAPHIC] Prioritizing Data Cleaning in 2022

June 13, 2022

Data cleaning is the process of going through your records to delete, correct, reformat, or alter information that is inaccurate to make space for new data. Data is the most important business asset, so ensuring its organized is crucial to support success. By prioritizing data cleaning, companies…

Continue reading
header image
Low Code & No Code

[INFOGRAPHIC] Low-Code No-Code: Benefits, Stats, & FAQs

June 9, 2022

The days of hand coding every application are over. Today, it’s becoming popular for developers and non-developers to adapt easy-to-use, low-code no-code software applications. These systems allow anyone to create applications and workflows with minimal to no coding knowledge.

Continue reading
header image

How StarfishETL Simplified My List Building & Targeting

We all know personalized marketing works. In fact, 86% of marketers who’ve implemented personalized campaigns see a measurable lift in results. And today’s customers expect that personalization, with 72% stating it’s the only kind of messaging they’ll engage with.

Continue reading...

How To, StarfishETL

Fixing the "Unable to translate bytes..." Error When Using the "CSV via Upload" Connector in StarfishETL

May 31, 2022

This error message is generally caused by “unknown, unrecognized, or unrepresentable characters”. You can find out if there is an issue with your file by opening the file in a text editor.

Continue reading
header image
Sales

How Sales Managers Can Use StarfishETL to Tighten the MQL to SQL Process

May 24, 2022

Businesses decide to integrate for many reasons, but two of the most common use cases we see are 1.) get customer financial information in the hands of sales and 2.) integrating to build alignment between sales and marketing. Understanding what a customer is purchasing, can help complete your…

Continue reading
header image

Tips for Optimizing your HubSpot Salesforce Integration

Integrating HubSpot and Salesforce is an important step towards shortening sales cycles and customizing marketing campaigns, but it must be done thoughtfully. Each platform has its own nuances, so to optimize the integration, you must first understand what you’re dealing with.

Continue reading...

Microsoft Exchange, StarfishETL

Introducing StarfishETL’s MS Exchange Graph API Connector

May 20, 2022

The wait is over! We are happy to announce a new connector for StarfishETL: the Exchange Graph API connector is now available. This will be a faster, more-secure connector for your Microsoft 365 integrations using StarfishETL.

Continue reading
header image
API

[INFOGRAPHIC] API Trends & Evolutions

May 16, 2022

Application Programming Interfaces (APIs) support the adaptability and automation all organizations are craving. They work as the middleman to help different applications understand and communicate with each other more effectively. This allows businesses to scale and innovate faster. In addition,…

Continue reading
header image

6 Best Practices for Eliminating Data Silos

Data silos can be an enemy to your organization. Teams must focus on breaking down data silos to maximize growth and increase profit margins. Incorporating effective strategies can help organize data and keep your teams on track to reach your goals.

Continue reading...

iPaaS

What Can iPaaS Do?

April 29, 2022

Businesses rely on iPaaS as a flexible, scalable way to integrate data, applications, and processes. When different systems are operating on separate platforms and data becomes misaligned, an iPaaS solution can unify those systems and create a centralized ecosystem to manage and modify data,…

Continue reading
header image- cloud technology
Data Archiving

[INFOGRAPHIC] Data Archiving: Key Functions, Best Practices, & Benefits

April 25, 2022

Data archiving is the process of removing unnecessary data files from your system and storing it in a safe location until it’s ready to be further processed. These steps are important for businesses of any size and are required by most industries.

Continue reading
header image
Tech Trends

7 Tech Companies with Successful Sustainable Initiatives

April 15, 2022

Big tech companies have been changing their ways and making concrete initiatives with hopes to protect the environment in the long run. Here are seven tech companies that are making the world a greener place.

Continue reading
header image
Data Governance

Planning Data Governance: Approach & Best Practices

April 11, 2022

Data governance sets a precedent for the processes, policies, standards, and metrics that inform the most effective use of a business’ information. It's a function that supports the company’s overall data management strategy to minimize risks, increase data value, cut costs, and make sure…

Continue reading
header image

[Infographic] Digital Transformation: Trends, Benefits, & the Future

Digital transformation is refining how companies are working. Better data collection and improved customer experiences will be beneficial for saving money and increasing profits. 70% of companies already have a digital transformation strategy or are working on one.  Are you? 

Continue reading...

Data Integration

What are API Integrations and Why are They Beneficial?

March 22, 2022

Businesses need connected data – we all know this. We also know that integrated solutions give those businesses the power to pull from larger, more diverse data sets as they build automation strategies, analyze metrics, and look for ways to build cost efficiencies.

Continue reading
header image
Tech Trends

10 Women in Tech You Should Know

March 17, 2022

Women’s history month is an opportunity to admire the work of women across all fields. We chose to showcase top women in the technology field that have made a difference in our society. Here are 10 women in tech you should know about:

Continue reading
header image
Data Integration

Popular CRM Integration Use Cases for Streamlined Operations

March 14, 2022

Businesses adopt CRMs to connect data for analysis and help consolidate information. An integrated CRM solution maximizes that investment by preventing duplicate data entry and increasing team productivity. Without CRM integration, teams end up having to switch between systems to piece together the…

Continue reading
header image
Tips and Tricks, Data Governance

Proactive Data Ethics for Better Business

March 1, 2022

Debates around how private businesses and governments use people’s data have been a hot topic over the past decade. Companies rely on customer data to retarget and personalize experiences, but consumers are pushing back on that data collection.

Continue reading
header image