BrightPearl QlikView Integration

    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 QlikView was to export data manually. But today with help from "ETL-tools QlikView connector" it is possible to automate it.

    BrightPearlTransformation.pngFollowing 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.

     

    About


    ETL-tools QlikView connector works directly with 23 data sources and it is the only one which can do complex data transformations while loading data into QlikView

    BrightPearlConnection1.png