Import from a database
Import product data from a database in Productsup.
You can request product data directly from a database. Productsup provides a selection of data sources for several types of databases. This lets you skip creating a feed file from the database for import.
You must query this database to receive your product information when you import from a database. See Write SQL database queries - tips to learn more.
Note
Productsup can add more drivers and database imports on request.
Import from an MYSQL database
If you work with a vast infrastructure and keep data in a MySQL database, use this importer to get your data into Productsup. This data source connects directly to your database. You can activate the proxy feature to only allow traffic from the Productsup proxy servers.
To import from an MYSQL database:
Go to Data Sources from your site's main menu and select ADD DATA SOURCE.
Select Add for the MYSQL Import data source.
(Optional) Give your data source a custom name. This custom name replaces the name of the data source on the Data Sources Overview page. Then, select Continue.
Add your hostname in Hostname to connect to your database.
In Port, add the port numbers you assigned to the database.
Add your credentials in the Username and Password fields to connect to the database.
Enter the database name in Database.
In Query, enter a query to select the relevant data.
In Charset, select your database charset from the drop-down list if known. Otherwise, the platform decides the charset by default.
Select Save.
Import from a PostgreSQL database
You can import data using a SQL Query. Productsup supports PostgreSQL UNICODE or PostgreSQL ANSI ODBC drivers.
Note
You should not execute queries from an online transactional database but instead from a database warehouse database or backup. Make sure the user assigned for the Productusp integration only has read access to the necessary tables to complete the query.
To import from a PostgreSQL database:
Go to Data Sources from your site's main menu and select ADD DATA SOURCE.
Select Add for the PostgreSQL data source.
(Optional) Give your data source a custom name. This custom name replaces the name of the data source on the Data Sources Overview page. Then, select Continue.
In Driver, choose the relevant driver. Select PostgreSQL UNICODE or Postgre ANSI from the drop-down list.
Add your hostname in Hostname to connect to your database.
In Port, add the port numbers you assigned to the database.
Enter the database name in Database.
Add your credentials in the Username and Password fields to connect to the database.
In Query, enter a query to select the relevant data.
Select Save.
Import from a Microsoft SQL Server database
You can import data using a SQL Query. Productsup supports ODBC Driver 17 for SQL Server.
Note
You should not execute queries from an online transactional database but instead from a database warehouse database or backup. Make sure the user assigned for the Productusp integration only has read access to the necessary tables to complete the query.
To import from an MS SQL Server database:
Go to Data Sources from your site's main menu and select ADD DATA SOURCE.
Select Add for the Microsoft SQL Server Import data source.
(Optional) Give your data source a custom name. This custom name replaces the name of the data source on the Data Sources Overview page. Then, select Continue.
Add your hostname in Hostname to connect to your database.
In Port, add the port numbers you assigned to the database.
Enter the database name in Database Name.
Add your credentials in the Username and Password fields to connect to the database.
In Query, enter a query to select the relevant data.
Select Save.
Import from an ODBC database
You can also connect to any SQL database based on Open Database Connectivity (ODBC). Productsup supports PostgreSQL UNICODE, PostgreSQL ANSI ODBC, and ODBC Driver 17 for SQL Server drivers.
Note
Support for more drivers can be added on request.
Note
You should not execute queries from an online transactional database but instead from a database warehouse database or backup. Make sure the user assigned for the Productusp integration only has read access to the necessary tables to complete the query.
Go to Data Sources from your site's main menu and select ADD DATA SOURCE.
Select Add for the ODBC database Import v1 data source.
(Optional) Give your data source a custom name. This custom name replaces the name of the data source on the Data Sources Overview page. Then, select Continue.
In Username, add the username (UID) in connect string to connect to your database.
Add your credentials from the ODBC connect string in the Password fields to connect to the database.
Enter the database name in Connection String.
Your database administrator should provide this name.
Add it in this format:
Driver={ODBC Driver 17 for SQL Server};Server=mssql.123testing.com;Database=tempdb;
In Query, enter a query to select the relevant data.
Select Save.
