Systems | Development | Analytics | API | Testing

%term

Loading complex CSV files into BigQuery using Google Sheets

BigQuery offers the ability to quickly import a CSV file, both from the web user interface and from the command line: Indeed, try to open this file up with BigQuery: and we get the errors like: This is because a row is spread across multiple lines, and so the starting quote on one line is never closed. This is not an easy problem to solve — lots of tools struggle with CSV files that have new lines inside cells. Google Sheets, on the other hand, has a much better CSV import mechanism.

Talend vs. MuleSoft vs. Xplenty: Which One Does ETL Better?

The key differences between Talend, MuleSoft, and Xplenty: Enterprise data volumes are increasing by 63 percent per month, according to a recent study. Twenty percent of organizations draw from 1,000 or more data sources. How do these companies extract and move all this data to a centralized destination for business analytics? As we know, Extract, Transform, and Load (ETL) streamlines this entire process. But smaller organizations lack the coding skills required for successful implementation.

How to Authenticate using Azure Active Directory

DreamFactory’s Azure AD connector makes it easy to use an Azure Active Directory tenant for API authentication. By using Azure AD Application Roles it is also possible to assign Users and Groups to DreamFactory roles from the Azure Portal. In this example, we will show how to quickly configure DreamFactory with the proper metadata from Microsoft Azure Active Directory (Azure AD).

Brick and Mortar Stores are Now Built Brick by Brick with Digital Insights

In my last three blogs (Get to Know Your Retail Customer: Accelerating Customer Insight and Relevance; Improving your Customer-Centric Merchandising with Location-based in-Store Merchandising; and Maximizing Supply Chain Agility through the “Last Mile” Commitment) I painted a picture that showed an ever-changing landscape in retail, considering that consumers are more in control than ever, mobile (at least somewhat digitally mobile considering the pandemic) and socially connected.

Top 5 trends for API-powered digital transformation in 2021

Our “State of the API Economy 2021” report confirms that though digital transformation has been among enterprises’ top business imperatives for years, the COVID-19 pandemic and changing market conditions have increased this urgency. Organizations across the world weathered the pandemic by compressing years of digital transformation into just a few months.

Testing a mobile application: an examination of strategy and tools

Mobile phones have taken over the world in a way few technologies and inventions have been able to in the past. The far-reaching repercussions of such a widely accepted adoption can be felt in all fields of life, from education to tourism. As mobile phone usage and internet penetration continue to grow at unprecedented rates, competition amongst developers is also at all-time heights. Hence, quality control and assurance within the mobile application development sector has become vital.

Service Connectivity Isn't Your Job, But it's Still Your Problem

As a developer, your company hired you to build incredible products that focus on your users’ and customers’ needs. Yet, in the age of microservices, producing the best products relies heavily on efficient cloud service connectivity. For example, an eCommerce marketplace is more than a front-end UI that customers access via a browser.

The Importance of Zero-Trust Security When Making the Microservices Move

Transitioning to microservices has many advantages for teams building large applications that must accelerate the pace of innovation, deployments and time to market. It also provides them the opportunity to secure their applications and services better than they did with monolithic codebases.