Improved Import / Export MAJOR UPDATE 3.0 - Excel, Json, XML, APIs, automation, mapping, attributes, consecutive run and more EXPLORE

"Database"

How to repair Magento 2 database

Magento 2 import export debug log

While Magento 1 offers an official tool designed to repair a database, nothing similar exists for Magento 2. You cannot find issues and fix them as quickly as most of us got used to. Indeed, there is an unofficial replacement for Magento 1 Database Repair Tool. Below, we shed light on how to repair the Magento 2 database in the most user-friendly manner. Besides, you will find out how to integrate Magento 2 with any external databases. Continue Reading

How to Import Any Table From Remote Database to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Database Import Integration

In the following article, we shed light on two ways of importing a table from a remote database to Magento 2. Firstly, we describe a universal approach and then shed light on an improved way. Besides, you will find a list of multiple guides to transferring information from particular databases. But let’s take a look at the difference between the two approaches first. Continue Reading

How to Import Data from Spark SQL to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Spark SQL Data Import

Do you know how to import a remote table from Spark SQL to Magento 2? Here at Firebear, we are familiar with at least two different methods, and the following article describes both of them. Firstly, we concentrate on a universal approach to transferring information from between the two systems. Secondly, this article sheds light on how to simplify and automate the data exchange. To make the long story short, let’s start the exploration of the first method. Continue Reading

How to Import Data from Impala to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Impala Data Import

Below, we shed light on the Magento 2 Impala synchronization. You can freely transfer information from the remote database right to your e-commerce website, and there are at least two ways to do that. Firstly, you can rely on the universal approach to data exchange between the two platforms. Secondly, there is a tool that dramatically improves that routine providing the ability to automate all the corresponding processes. Let’s explore the universal approach first. Continue Reading

How to Import Data from BigQuery to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 BigQuery Data Import

In the following article, we explore the Magento 2 BigQuery integration. If your partner provides updates via this remote database, you will find out two ways of importing the information back to your e-commerce store. Firstly, we shed light on a universal approach which is more complicated and slow. Secondly, you will discover how to replace its steps with a user-friendly process which can be fully automized. To make the long story short, let’s see how to move BigQuery tables into Magento 2 using the common approach. Continue Reading

How to import data from Amazon Redshift to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Amazon Redshift Data Import

The following article compares two different approaches to importing data from Amazon Redshift to Magento 2. First of all, we describe a community-proven way of moving a remote table from one system to another. As you might have already guessed, it still has a room for improvement. Next, we provide a more efficient solution. Let’s see how most of us import data from Amazon Redshift to Magento 2. Continue Reading

How to Import Data from Teradata to Magento 2

- E-Commerce, Magento 2, Our extensions

Magento 2 Teradata Data Import

In the following article, we discuss the improved approach to data import from Teradata to Magento 2. Although there is a community-accepted approach (described below as well), we propose a more user-friendly way of integration. Being based on a third-party extension, it not only moves all routine processes to a single environment but also allows automating them. Consequently, you no longer need to spend time on importing data from Teradata to Magento 2 daily. But let’s describe the common approach before discussing the enhanced one. Continue Reading