No I don't see the relations between tables, that's the problem. I also have tried to introduce only the main tables and I see that if I clik into the schema editor the other tables ( related with the constraints with main one) are introduced automatically by Biomart. In this case I can add a tab with a new entry and I can select the attributes of the main table (by the web) but unfortunately I neither see the relations nor the attributes of the other tables.
Thanks -----Mensaje original----- De: [email protected] en nombre de Arek Kasprzyk Enviado el: lun 23/01/2012 17:01 Para: PROTASIO, JOAN (IDIBAPS) CC: [email protected] Asunto: Re: [BioMart Users] Problems adding source with constraints Hi Joan, do you see the relations between tables as well? a On Mon, Jan 23, 2012 at 10:44 AM, <[email protected]> wrote: > Hi Arek,**** > > ** ** > > well I'm choosing exactly the params source schema-> MySQL and I uncheck > the MYlSAM option because the schema of my local db works with InnoDB. > Afterthat I can see the source with all the tables involved in the schema. > Then if I select all of them I see various sources in my MartConfigurator. > **** > > ** ** > > Salutacions, **** > > Joan **** > > **** > > > ------------------------------------------------------------------------------ > **** > > **** > > Joan Protasio**** > > *Bioinformatics Unit: *http://bioinformatics.fcrb.es/bioinformatics/**** > > August Pi i Sunyer Biomedical Research Institute (IDIBAPS)**** > > Phone: 93.227.54.00 (Ext. 4522)**** > > C/ Rosselló 153**** > > 08036 Barcelona**** > > ** ** > > ** ** > > ** ** > > ** ** > > ** ** > > ** ** > ------------------------------ > > *De:* [email protected] [mailto:[email protected]] *En > nombre de *Arek Kasprzyk > *Enviado el:* lunes, 23 de enero de 2012 16:04 > *Para:* PROTASIO, JOAN (IDIBAPS) > *CC:* [email protected] > *Asunto:* Re: [BioMart Users] Problems adding source with constraints**** > > ** ** > > Hi Joan,**** > > first of all you need to be aware that rc7 has not been officially > released. I am not sure how much testing gone into that. The last official > release is rc6. InnoDB should definitely work and behave just like oracle > or postgres. Are you choosing the right DB platform option ei NOT MySQL > MyISM?**** > > ** ** > > a**** > > ** ** > > On Mon, Jan 23, 2012 at 7:35 AM, <[email protected]> wrote:**** > > Hi all,**** > > **** > > I have problems adding new source from a local database. I am working with > the new Biomart version r7 and the local database works with constraints in > InnoDB format. If I try to add the source using the MartConfigurator and > click into the Schema Editor I don't see the relations like the mysql > constraints. I have read the paper "Biomart: a data federation framework." > and if I understand it well it says the source must be a relational db as > we have but I am not sure if the InnoDB format is good for Biomart. Could > you help me?**** > > **** > > Thanks a lot,**** > > **** > > Salutacions, **** > > Joan **** > > **** > > > ------------------------------------------------------------------------------ > **** > > **** > > Joan Protasio**** > > *Bioinformatics Unit: *http://bioinformatics.fcrb.es/bioinformatics/**** > > August Pi i Sunyer Biomedical Research Institute (IDIBAPS)**** > > Phone: 93.227.54.00 (Ext. 4522)**** > > C/ Rosselló 153**** > > 08036 Barcelona**** > > > _______________________________________________ > Users mailing list > [email protected] > https://lists.biomart.org/mailman/listinfo/users**** > > > > **** > > ** ** > > -- **** > > Arek Kasprzyk, MD, MSc, PhD > BioMart Project Lead**** > > ** ** > -- Arek Kasprzyk, MD, MSc, PhD BioMart Project Lead _______________________________________________ Users mailing list [email protected] https://lists.biomart.org/mailman/listinfo/users
