The generic SQL connector is now available in our Add System Wizard. Simply click on the '+SYSTEM' button at the top-right and choose 'Use wizard to create a system', then search for 'SQL'.
When you have added the 'SQL' system onto the canvas, select it and start adding and configuring endpoints from the right sidebar.
You will be able to define the table name from which you want to fetch data (source SQL) or to which you want to send updates (destination SQL), as well as define the data structure using our standard data layout functionality and build your own query via configurable WHERE clause.
The configured endpoint can then be linked to any other endpoint available in DSYNC (ie. RSS Feed, FTP, API, Excel file etc).
PostgreSQL - Integration tool:
Use DSYNC to integrate into your PostgreSQL database and combine with 3rd Party API's and connectors. Connect multiple types of data including
- Order Data, Sales Price data, Shipping and Inventory, Stock, multiple endpoints Integration
- Customer Data Integration
- Product and Inventory Integration
PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards compliance. Database integration tools
PostreSQL for API and integration
Use DSYNC to connect your multiple apps including:
- PostgreSQL databases integration with Magento1 and Magento2
- PostgreSQL database integration with WooCommerce
- PostgreSQL database integration with Revel Point of Sale
- PostgreSQL database integration with Vend Hq Point of Sale
- PostgreSQL database integration with BigCommerce
- PostgreSQL database integration with Shopify
- PostgreSQL database integration with Unleashed inventory
- PostgreSQL database integration with custom Rest API
- PostgreSQL database integration with systems you build via our SDK
- PostgreSQL database integration with mailchimp
- PostgreSQL database integration with Xero Accounting
- PostgreSQL database integration with Quickbooks Accounting
- PostgreSQL database integration with Shipstation
- PostgreSQL database integration with with Shippo
- PostgreSQL database integration with with BI tools and reports
- PostgreSQL database integration with Marketplacer
Transform data via DSYNC to meet you PostgreSQL database custom needs
Use DSYNC with PostgreSQL to set regular expression rules to transform data to your APPs
Integrate Custom ERPs and PostgreSQL together
Some more info on PostgreSQL:
PostgreSQL is well supported by its active community. There are more than a dozen mailing lists available, categorized into topics like administration, announcements, jobs, performance, and SQL. PostgreSQL also have several PostgreSQL User Groups in the world, and there is also an active IRC community.PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, macOS, Solaris, Tru64), and Windows.
PostgreSQL is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others
An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. Find out more about PostgreSQL database