topic Re: Alfresco Share MetaDBConnector Component Released! in Alfresco Archive

Alfresco Share MetaDBConnector Component Released!

venzia — Thu, 19 Apr 2012 09:46:07 GMT

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 st

Re: Alfresco Share MetaDBConnector Component Released!

need — Thu, 19 Apr 2012 09:50:58 GMT

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?

Re: Alfresco Share MetaDBConnector Component Released!

venzia — Thu, 19 Apr 2012 16:25:55 GMT

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!

Re: Alfresco Share MetaDBConnector Component Released!

need — Fri, 20 Apr 2012 07:56:44 GMT

Wow,

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

Thanks.

Re: Alfresco Share MetaDBConnector Component Released!

nagpalvikas — Thu, 10 May 2012 14:10:34 GMT

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.

Re: Alfresco Share MetaDBConnector Component Released!

venzia — Fri, 11 May 2012 17:19:33 GMT

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!

Re: Alfresco Share MetaDBConnector Component Released!

dcambier — Mon, 04 Nov 2013 20:45:17 GMT

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

Re: Alfresco Share MetaDBConnector Component Released!

venzia — Wed, 13 Nov 2013 08:41:59 GMT

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!