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/ <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/ <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
_______________________________________________ Users mailing list [email protected] https://lists.biomart.org/mailman/listinfo/users
