CMDBuild Forum

CMDB synchronisation with external sources

Hello,

I came across an information that cmdbuild contains a daemon that is able to sync data with an external data sources and I know behind this feature is quartz scheduler. But, what I can't figure out is how to configure it in CMDBuild. 

Could someone experienced in this matter give me a lead where to look to get an idea how to configure sync data scheduling? CMDBuild manuals unfortunately lack this information.

I would prefer using integrated feature over scripting my own logic to implement data sync.

Thanks!

 

 

 

 

 

The current version of CMDBuild has a Basic Connector (downloadable from here http://www.cmdbuild.org/it/download) and an Advanced Connector (not open source). Both must be scheduled with the system cron.
The next
CMDBuild version 2.2 (to be released in a month and a half) will include a new Connector Wizard schedulable with Quartz and will include a new Connectors Manual.
CMDBuild Team

 

 

 

 

 

Thank you for the reply.
From what I read in the attached basic connector reference I see data source is nothing but database. 
I cannot use csv or formatted xml as a datasource, and therefore I must work on my own solution. That is read input data from csv files and through soap messages update existing cards.
 
Previously Tecnoteca wrote:
The current version of CMDBuild has a Basic Connector (downloadable from here http://www.cmdbuild.org/it/download) and an Advanced Connector (not open source). Both must be scheduled with the system cron.
The next
CMDBuild version 2.2 (to be released in a month and a half) will include a new Connector Wizard schedulable with Quartz and will include a new Connectors Manual.
CMDBuild Team

 

 

 

 

 

 

I have one more question if I may.
How could be relations synchronized ?
 
Previously Tecnoteca wrote:
The current version of CMDBuild has a Basic Connector (downloadable from here http://www.cmdbuild.org/it/download) and an Advanced Connector (not open source). Both must be scheduled with the system cron.
The next
CMDBuild version 2.2 (to be released in a month and a half) will include a new Connector Wizard schedulable with Quartz and will include a new Connectors Manual.
CMDBuild Team

 

 

 

 

 

 

If the connectors have a unique key to compare the CMDBuild items with the external systems items, they can also compare the current relationship with the previous relationship and update them.
CMDBuild Team

Previously Tecnoteca wrote:

If the connectors have a unique key to compare the CMDBuild items with the external systems items, they can also compare the current relationship with the previous relationship and update them.
CMDBuild Team
Hi
thank you for this interesting tool 
For me i can update by wizard connector from mysql BDD, but i can't update reference class 1: N 
Is this possible at first to realize through the wizard ?
If Yes How
Thanks
 

No, this first implementation of the Wizard Connector can only handle the situation of an external table to be syncronized in a CMDBuild class.

Next released will cover more cases.
CMDBuild Team

Previously Tecnoteca wrote:

No, this first implementation of the Wizard Connector can only handle the situation of an external table to be syncronized in a CMDBuild class.

Next released will cover more cases.
CMDBuild Team
 
thank you for your reply 
In the documentation "connectors manual" I found this for wizard: 
 
Each instance can synchronize only one main class and the classes connected with detail 
1: N domain 
 
best regards

At this moment you can map “n” rows of the source table in one master row and “n” detail rows of two CMDBuild classes.
However, in the version 2.2.1 is missing the part that creates the relations between the master and the details card, so we consider that this feature is still incomplete.
CMDBuild Team

Previously Tecnoteca wrote:

At this moment you can map "n" rows of the source table in one master row and "n" detail rows of two CMDBuild classes.
However, in the version 2.2.1 is missing the part that creates the relations between the master and the details card, so we consider that this feature is still incomplete.
CMDBuild Team

 

Hi
Thank you I hope to include this relation between master and detail in the wizard. 
However I bypassed the problem by adding in first the reltaion master / detail from the menu (setup) by (csv import) and using the wizard to update the other attributes in a second phase