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:

  1. Navigate to your site

  2. Navigate to data sources

  3. Click add data source

  4. Add the MYSQL Import data source

  5. Give your data source a specialized name (if desired)

    1. This will replace the name of the data source option in the data sources overview page

  6. Click continue

  7. Add in the hostname to connect to your database

  8. Add in the number of the port which has been assigned to the database

  9. Add in the username and password to connect to the database

  10. Add in a query to select the relevant data

  11. Set your database charset if known

  12. Add a description (if desired)

    1. This is another chance to add a specialized name (see step 5)

  13. Click save

    mysql.png

Import from a PostgreSQL database

To import from a PostgreSQL database, you should:

  1. Navigate to your site

  2. Navigate to data sources

  3. Click add data source

  4. Add the PostgreSQL data source

  5. Give your data source a specialized name (if desired)

    1. This will replace the name of the data source option in the data sources overview page

  6. Click continue

  7. Select the relevant driver (either UNICODE or ANSI)

  8. Add in the hostname to connect to your database

  9. Add in the number of the port which has been assigned to the database

  10. Add in the name of your database which you want to access under database name

  11. Add in the username and password to connect to the database

  12. Add in a query to select the relevant data

  13. Add a description (if desired)

    1. This is another chance to add a specialized name (see step 5)

  14. Click save

    postgresql.png

Import from a Microsoft SQL Server database

To import from an MS SQL Server database, you should:

  1. Navigate to your site

  2. Navigate to data sources

  3. Click add data source

  4. Add the Microsoft SQL Server Import data source

  5. Give your data source a specialized name (if desired)

    1. This will replace the name of the data source option in the data sources overview page

  6. Click continue

  7. Add in the hostname to connect to your database

  8. Add in the number of the port which has been assigned to the database

  9. Add in the name of your database which you want to access under database name

  10. Add in the username and password to connect to the database

  11. Add in a query to select the relevant data

  12. Add a description (if desired)

    1. This is another chance to add a specialized name (see step 5)

  13. Click save

    mssql.png

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.

  1. Navigate to your site

  2. Navigate to data sources

  3. Click add data source

  4. Add the ODBC database import data source

  5. Give your data source a specialized name (if desired)

    1. This will replace the name of the data source option in the data sources overview page

  6. Click continue

  7. Add in the connection string

    1. this should be provided by your database administrator

    2. it should be added in a format like: Driver={ODBC Driver 17 for SQL Server};Server=mssql.123testing.com;Database=tempdb;

  8. Add in the username and password to connect to the database

  9. Add in a query to select the relevant data

  10. Add a description (if desired)

    1. This is another chance to add a specialized name (see step 5)

  11. Click save

    odbc.png