Module Import:Database extends Import Feeds to automate data synchronization directly from your remote databases, eliminating the need for manual file exports and uploads.
Connect to your existing MySQL, PostgreSQL, or MSSQL databases and import data using flexible SQL queries that can join multiple tables, filter records, and transform data on-the-fly. Schedule regular imports via Scheduled Jobs to keep your AtroCore data synchronized automatically, ensuring your system always has the latest information without manual intervention.
Other database types (Oracle, HANA, MariaDB, etc.) can be added upon request — contact us if needed.
Module
Import Feedsis required for this module to work.
Configuration
Import feed configuration works the same for all import feed types, except for the Data Sourcing section which is specific to each type. See Import Feeds for general import feed setup—skip the Data Sourcing section there as it describes file-based imports.
Create an Import Feed with Sourcing Type set to Database. In the Data Sourcing section:
- Connection – select or create a Connection of the required type: MySQL, PostgreSQL, or MSSQL. PDO SQL connections are also available.
- Query – SQL query to select data from your database. You can query a single table or join multiple tables.
After setting up the connection and query, click Get sample data to execute the query and populate the Source Fields list based on the results.
All other aspects of import feed configuration and usage are the same as for file-based imports: field mapping in the Configurator, running imports, import jobs, error handling, and all other features described in Import Feeds.