Hi all! .. I have the pleasure to announce the release of our Alfresco MetaDBConnector Component. You can download it from http://addons.alfresco.com/addons/alfresco-metadbconnector-component (the sources will be soon). But, Why would we use is this component? .. because "basically" it allow to store structured data (that obtain from externals databases) in content metadata on Alfresco. This functionality provides a new great range of possibilities that you can discover if you try .. (integration with other corporate systems, replace complex Alfresco Constraints, content enrichment, externalization, etc…)
From VenziaIT hope will be of your interest and generate new opportunities. Greetings! PS: From the follow link you will have all the info about it that we publish on our corporate blog http://venzia.es/tags/metadbconnector
Hi need, thanks for comments! ;D .. In relation to your questions :
The connector file properties support the join?
Initially we recommend use of Views o Temporary Tables in complex or critical environments, which is required access to information of two or more tables/schemas. Thus, the connector performs the query on the View or Temporary Table. However I can confirm that you can perform joins between tables. This is a hypothetical example with the tables of city and country of sakilaDB : NOTE : You can generate a new connector if you wish, although no documentation is available for this (soon) and may be somewhat complex to perform. For test you can modify existing connectors leaving the properties "name, title, description and aspect of xml file" as they are to avoid having to generate the new aspect and labels.
<?xml version="1.0" encoding="UTF-8"?><connectors> <connector> <name>cities</name> <!– for fast test leave countries –> <title>Cities</title> <!– for fast test leave Countries –> <description>Cities List</description> <aspect>mdbc:city</aspect> <!– for fast test leave mdbc:country –> <column-detail>city.city</column-detail> <driver-class-name>com.mysql.jdbc.Driver</driver-class-name> <url>jdbc:mysql://127.0.0.1:3306/sakila</url> <username>root</username> <password>*****</password> <table>city INNER JOIN country ON city.country_id=country.country_id</table> <where>country like '%{0}%' OR city like '%{0}%'</where> <columns> <column name="city_id" primary-key="true" label="Code" visible="false" order="1" width="20"/> <column name="city" label="City" order="2" width="120"/> <column name="country" label="Country" order="2" width="120"/> </columns> </connector></connectors>
This change allow us to query and to show fields of two tables. As you can see the possibilities are many .. I hope I have resolved your doubts. Greetings!
I installed the connector on Windows 2008 R2 server on a fresh Alfresco Enterprise 4.0 installation. I followed the instructions from the AdminUserGuide.
I fulfilled the prerequisite: "An Alfresco instance running and jdbc driver jar file in tomcat/lib folder (if different to MySQL)."
but not: "Installation of AMP module in alfresco.war, sakilaDB files in local (or accesible) MySQL server and copy of jar file in Share webapp lib folder." as I am trying to connect to MS-SQL. Instead of command:
Hi dcambier, the idea is to use the Alfresco database as source and query against datalist items. For that you need to know which are the differences between a normal content and a datalistitem, I mean, you need to analyse Alfresco database (alf_node_properties), design the query to obtain the datalistitems only and then apply that query and the filter that you want to use in "connector" config file.
