Integration of Dolibarr to the Airbyte data integration platform: Difference between revisions

Jump to navigation Jump to search
m
no edit summary
mNo edit summary
Line 1: Line 1:
==='''Introduction'''===
=='''Introduction'''==
Airbyte is an open-source ELT platform that allows to create data integration streams with no code interface, in this tutorial will be explained the use of the Dolibarr source connector available in the marketplace of the different options of Airbyte installations. This connector also could be edited, personalized, and updated to contribute by the users through the graphic UI Connector Builder of the Airbyte platform.
Airbyte is an open-source ELT platform that allows to create data integration streams with no code interface, in this tutorial will be explained the use of the Dolibarr source connector available in the marketplace of the different options of Airbyte installations. This connector also could be edited, personalized, and updated to contribute by the users through the graphic UI Connector Builder of the Airbyte platform.


==='''Prerequisites'''===
=='''Prerequisites'''==
For this guide you need to complete the following prerequisites:  
For this guide you need to complete the following prerequisites:  


Line 12: Line 12:
*Give read permissions, to the user with the API key generated, for the modules that will be source of data in the data extraction streams. (Some streams or end points, like GET company information, will require that your user be administrator or have read/write permissions to works fine with the GET end point)
*Give read permissions, to the user with the API key generated, for the modules that will be source of data in the data extraction streams. (Some streams or end points, like GET company information, will require that your user be administrator or have read/write permissions to works fine with the GET end point)


==='''Create the Airbyte Connection'''===
=='''Create the Airbyte Connection'''==
Access to your Airbyte installation.
Access to your Airbyte installation.


Line 21: Line 21:
When you have your Airbyte instance, now you can create a connection where you will select a source and destination. In this guide we will only do the Dolibarr source connector configuration, but you can select any destination connector from the available options and follow the specific configuration guide for each one.
When you have your Airbyte instance, now you can create a connection where you will select a source and destination. In this guide we will only do the Dolibarr source connector configuration, but you can select any destination connector from the available options and follow the specific configuration guide for each one.


====1.     Select Dolibar source connector.====  
==== Select Dolibar source connector. ====
[[File:Airbyte 1Captura de pantalla 2025-07-03 234202.png|thumb|Dolibarr source connector selection in Airbyte]]
[[File:Airbyte 1Captura de pantalla 2025-07-03 234202.png|thumb|Dolibarr source connector selection in Airbyte]]
In the home page of your Airbyte installation select the bottom “Create Connection”, then you will be able to select the source connector from a list. You must select Dolibarr connector from the Marketplace connectors list.  
In the home page of your Airbyte installation select the bottom “Create Connection”, then you will be able to select the source connector from a list. You must select Dolibarr connector from the Marketplace connectors list.  


You can find additional documentation of the Dolibarr source connector in: https://docs.airbyte.com/integrations/sources/dolibarr<br />
You can find additional documentation of the Dolibarr source connector in: https://docs.airbyte.com/integrations/sources/dolibarr<br />
====2.     Enter the authentication credentials for the Dolibarr connector:====
 
==== Enter the authentication credentials for the Dolibarr connector: ====
After selecting the Dolibarr source connector you will be required to enter the public domain of your Dolibarr instance (please follow the Dolibarr connector instructions that appears in Airbyte) and the API key that you previously configured for your Dolibarr user.
After selecting the Dolibarr source connector you will be required to enter the public domain of your Dolibarr instance (please follow the Dolibarr connector instructions that appears in Airbyte) and the API key that you previously configured for your Dolibarr user.


Line 37: Line 38:


<br />
<br />
====3.     Select the sync mode and streams for the schema:====
====Select the sync mode and streams for the schema:====
After the source and destination connector configuration, you need to select the sync mode you want and the streams and fields you want to include in your schema of the data you will extract and synchronize. For each stream in your schema, you will be able to select the sync mode, is recommended to select “Full refresh | overwrite” initially and if you want to enable the incremental sync modes you will need to validate the compatibility with your destination doing some sync tests.
After the source and destination connector configuration, you need to select the sync mode you want and the streams and fields you want to include in your schema of the data you will extract and synchronize. For each stream in your schema, you will be able to select the sync mode, is recommended to select “Full refresh | overwrite” initially and if you want to enable the incremental sync modes you will need to validate the compatibility with your destination doing some sync tests.
[[File:Airbyte 3Captura de pantalla 2025-07-03 234344.png|thumb|Dolibarr source connector - sync mode, streams and fields schema selection in Airbyte]]
[[File:Airbyte 3Captura de pantalla 2025-07-03 234344.png|thumb|Dolibarr source connector - sync mode, streams and fields schema selection in Airbyte]]
Line 48: Line 49:
{| class="wikitable"
{| class="wikitable"
| colspan="2" |
| colspan="2" |
===='''Overview of streams or data tables with important column names on each sheet and their corresponding meaning'''====
===='''Overview of streams or data tables with important column names on each sheet and their corresponding meaning'''====
|-
|-
|
|
Line 539: Line 540:
|}
|}


====4.     Connection configuration:====
====Final connection configuration:====
[[File:Airbyte 4Captura de pantalla 2025-07-04 000006.png|thumb|Dolibarr source connector - final connection configuration in Airbyte]]
[[File:Airbyte 4Captura de pantalla 2025-07-04 000006.png|thumb|Dolibarr source connector - final connection configuration in Airbyte]]


Line 546: Line 547:
Finally, you must configure the name, schedule type, frequency and destination namespace for your connection. After these definitions you could save your connection and Airbyte will execute the first synchronization.
Finally, you must configure the name, schedule type, frequency and destination namespace for your connection. After these definitions you could save your connection and Airbyte will execute the first synchronization.
<br />
<br />
==='''Go further'''===
=='''Go further'''==
The Dolibarr source connector in Airbyte will let you modify and customize the streams, fields and API methods used by editing the connector in the UI Connector Builder, is important that you explore the Airbyte public documentation (<nowiki>https://docs.airbyte.com/platform/connector-development/connector-builder-ui/overview</nowiki> ) to make improvements to your connectors and get the maximum benefits of the Dolibarr data integration with this tool and contribute to the connector update.
The Dolibarr source connector in Airbyte will let you modify and customize the streams, fields and API methods used by editing the connector in the UI Connector Builder, is important that you explore the Airbyte public documentation (<nowiki>https://docs.airbyte.com/platform/connector-development/connector-builder-ui/overview</nowiki> ) to make improvements to your connectors and get the maximum benefits of the Dolibarr data integration with this tool and contribute to the connector update.


==='''Conclusion'''===
=='''Conclusion'''==
Airbyte is versatile and powerful open source tool that allows you to create a no code data integrations between Dolibarr and many third-party applications using the Wbe services API REST to explode your operational data in analytics, business intelligence, AI tools to have added value from your data to make business decisions.
Airbyte is versatile and powerful open source tool that allows you to create a no code data integrations between Dolibarr and many third-party applications using the Wbe services API REST to explode your operational data in analytics, business intelligence, AI tools to have added value from your data to make business decisions.
17

edits

Navigation menu