Brightpearl is a fully integrated, web-based business management software system. It allows you to run all your business processes through one piece of software, so you no longer have to suffer the pain of transferring data between multiple different business systems. All your business's information is visible in real-time across every department whether it is entered via your website, inventory control, accounts or CRM.

Until now the only way to prepare data for Datawarehouse was to export data manually. But today with help from Advanced ETL processor it is possible to automate loading data from Brightpearl.

Following data can be extracted

brand
http://www.brightpearl.com/developer/latest/product/brand/search.html

brightpearl-category
http://www.brightpearl.com/developer/latest/product/brightpearl-category/search.html

contact
http://www.brightpearl.com/developer/latest/contact/contact/search.html

order
Search
http://www.brightpearl.com/developer/latest/order/order/search.html
List of fields
http://www.brightpearl.com/developer/latest/order/order/get.html

option
http://www.brightpearl.com/developer/latest/product/option/search.html

option-value
http://www.brightpearl.com/developer/latest/product/option%20value/search.html

product
http://www.brightpearl.com/developer/latest/product/product/search.html

product-type
http://www.brightpearl.com/developer/latest/product/product-type/search.html

goods-in-note
http://www.brightpearl.com/developer/latest/warehouse/goods-in-note/search.html

goods-out-note
http://www.brightpearl.com/developer/latest/warehouse/goods-out-note/search.html

Additional parameters can be passed using search string

As described here

http://www.brightpearl.com/developer/latest/tutorial/working-with-resource-search.html

Columns

Each resource search supports a set of fixed set of columns - data that will be included in your results like contact names and email addresses. By default, every result will include a value for each column (although that value may be null) it is possible to change the set and order of the columns returned in the results.

You can constrain your search by specifying one or more column names as query parameters in your resource search URI. For example:

primaryEmail=brightpearl.com&firstName=Ben

will only include results where the contact's email address contains brightpearl.com and their first name contains Ben.

BrightPearl data Integration solution 

Direct link, no registration required.
Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 
 
Xerox
Swiss banking
Bank Of Oklahoma
Red Cross
Alta Pacific bank
Copeinca
Gas alberta
NHS
Royal Brunei
First Oklahoma bank
Noresco
Iqvia

Testimonials

What customers say about us

  • swissbanking

    I used Advanced ETL Processor in 2 Enterprises for many business processes and Business automation (outside finance department). I did not find any other tool with so many functions and broad flexibility for that Price! If you need support for bugs or solution design you will get it very fast. Best Support I have ever seen.

    Lionel Albrecht
  • iqvia

    IQVIA and DB Software Laboratory (DBSL) partnered in 2010 and have been working in close cooperation ever since. Over this period of time, DBSL software components formed an integral part of a large number of IQVIA applications currently used by over 20 UK NHS Trusts (Hospitals).

    Dmitry Dorsky,
    Director
  • xerox

    The product is easy to learn and once a developer understands the ETL way for solving the problem at hand, the developer's productivity will increase. Even our DBAs now uses the ETL software to quickly create solutions instead of SSIS or SQL jobs.

    Daniel Fung
    Solutions Architect

Read ETL Software customers feedback

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies