Alfresco Share MetaDBConnector Component Released!

[venzia]

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

[need]

Hi,

i have downloaded this component and i try on windows with mysql DataBase and works fine! Thanks a lot for your big and powerful works.

The connector file properties support the join?

[venzia]

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!

[need]

Wow,

thanks for the good advice  :wink: , i will try this.

Thanks.

[nagpalvikas]

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:

sudo java -jar bin/alfresco-mmt.jar install amps/mdbc-1.0-SNAPSHOT.amp tomcat/webapps/alfresco.war

I used the following:

java -jar bin/alfresco-mmt.jar install amps/mdbc-1.0-SNAPSHOT.amp tomcat/webapps/alfresco.war

as I am installing on windows and not UNIX.

Now I cannot login into http://127.0.0.1:8080/share/

Error: The remote server may be unavailable or your authentication details have not been recognized.

Please help.

[venzia]

Hi Vikas, as you know this is the link to the post of Google Code project which solved the problem http://code.google.com/p/alfresco-metadbconnector/issues/detail?id=1&can=1.
Useful for those who have your same problem.
Greetings!

[dcambier]

Hi,

I see this video : http://www.youtube.com/watch?v=KsdIUYWMpk4&feature=share&list=UUjnXuKngZWooov8a8NYLBSA

Could you explain how to use datalist with metadbconnector ?

Thanks
David

[venzia]

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.

Regards!