Import from a database
Import product data from a database in Productsup.
Product data can be directly requested from a database. Productsup provides a selection of Data Sources for several types of databases. This way, the step to create a feed file from the database to be imported can be skipped.
When importing from a database, you must query this database to receive your product information. To learn more about queries, see Write SQL database queries - tips.
Note
More drivers and thus database imports can be added on request.
Import from a MYSQL database
To import from a MYSQL database, you should:
Navigate to your site
Navigate to data sources
Click add data source
Add the MYSQL Import data source
Give your data source a specialized name (if desired)
This will replace the name of the data source option in the data sources overview page
Click continue
Add in the hostname to connect to your database
Add in the number of the port which has been assigned to the database
Add in the username and password to connect to the database
Add in a query to select the relevant data
Set your database charset if known
Add a description (if desired)
This is another chance to add a specialized name (see step 5)
Click save
Import from a PostgreSQL database
To import from a PostgreSQL database, you should:
Navigate to your site
Navigate to data sources
Click add data source
Add the PostgreSQL data source
Give your data source a specialized name (if desired)
This will replace the name of the data source option in the data sources overview page
Click continue
Select the relevant driver (either UNICODE or ANSI)
Add in the hostname to connect to your database
Add in the number of the port which has been assigned to the database
Add in the name of your database which you want to access under database name
Add in the username and password to connect to the database
Add in a query to select the relevant data
Add a description (if desired)
This is another chance to add a specialized name (see step 5)
Click save
Import from a Microsoft SQL Server database
To import from an MS SQL Server database, you should:
Navigate to your site
Navigate to data sources
Click add data source
Add the Microsoft SQL Server Import data source
Give your data source a specialized name (if desired)
This will replace the name of the data source option in the data sources overview page
Click continue
Add in the hostname to connect to your database
Add in the number of the port which has been assigned to the database
Add in the name of your database which you want to access under database name
Add in the username and password to connect to the database
Add in a query to select the relevant data
Add a description (if desired)
This is another chance to add a specialized name (see step 5)
Click save
Import from an ODBC database
You can also connect to any SQL database based on Open Database Connectivity (ODBC). In order to do so:
Note
Support for more drivers can be added on request.
Navigate to your site
Navigate to data sources
Click add data source
Add the ODBC database import data source
Give your data source a specialized name (if desired)
This will replace the name of the data source option in the data sources overview page
Click continue
Add in the connection string
this should be provided by your database administrator
it should be added in a format like:
Driver={ODBC Driver 17 for SQL Server};Server=mssql.123testing.com;Database=tempdb;
Add in the username and password to connect to the database
Add in a query to select the relevant data
Add a description (if desired)
This is another chance to add a specialized name (see step 5)
Click save