Hi,
This is probably straight forward to everyone else, but i cant figure out how to use a sql server as a source for external data synchronisation.
I'd like to sync my instance of CMDbuild (data such as classes/tables and cards/data inside the table) with an already existing sql server database source.
Is there a step-by-step guide somewhere or a more detailed manual? I read the Basic Connector manual but failed to understand how to make it work.
1. how many n what views to be created exactly?
2. is it compulsory to create a process?
3. where exactly do i place the connector?
4. when will the data sync take place?
5. how does this work?
and many more?
Also, do we have an example for connector with a sql server?
You can configure an external connector using one of the available frameworks: the Basic Connector (you can find it in the download page), or the Advanced Connector (not open source).
if your synchronization mapping criteria are simple (one table / view SQL * Server => one class CMDBuild) we recommend that you wait CMDBuild version 2.2 that we will release in three weeks and that will have a new wizard to configure and schedule the connector in a visual way from the CMDBuild Administration Module.
CMDBuild Team
Previously Tecnoteca wrote:
You can configure an external connector using one of the available frameworks: the Basic Connector (you can find it in the download page), or the Advanced Connector (not open source).
if your synchronization mapping criteria are simple (one table / view SQL * Server => one class CMDBuild) we recommend that you wait CMDBuild version 2.2 that we will release in three weeks and that will have a new wizard to configure and schedule the connector in a visual way from the CMDBuild Administration Module.
CMDBuild Team
Thanks a lot..but i need it early and it is not always a 1 table :1 CMDB class case; there may be need for "master" views(joins on some table) as well..i managed to understand how the views are to be created.. now my doubts would be:
1. Do I still need to creata a process? (is it compulsory?)
2. Where do i place the schema.xml , configuration.xml. transform.xml and the log4j.conf folder structure with respect to my CMDBuild instance? does it have to be the same folder? any place in the server?
3. How do I start the connector? is there a way from CMDBUild? if yes..how? if no..does it always have to be via the java command?
To help you I can send to you privately a draft of the new Connectors Manual that will be released with 2.2 CMDBuild.
CMDBuild Team