hi Arek,
Took me a little while to get all the details. We have one main table:
RGD_GENES__GENES__MAIN
--------------------------------------------
RGD_ID_KEY NUMBER
GENE_SYMBOL VARCHAR2
GENE_NAME VARCHAR2
GENE_DESC VARCHAR2
It has data in it (23k rows), the RGD_ID_KEY is set as the primary
key for the table. We have a number of other dimension tables, all
named RGD_GENES__xxxxx__DM, here's a representative example:
RGD_GENES__GENOME_V3_1_MAP__DM
-------------------------------------------------------------
RGD_ID_KEY NUMBER
MAP_NAME VARCHAR2
CHROMOSOME VARCHAR2
STRAND VARCHAR2
START_POS NUMBER
STOP_POS NUMBER
These also all have data in them, dumped directly from the RGD schema
via SQL. We havent defined foreign key constraints between the
RGD_ID_KEY values in the __DM tables back to the RGD_ID_KEY in the
__MAIN table but we could certainly add those in.
From what I can see, assuming that the case doesnt matter, the
tables are named correctly, the keys are named correctly (presumably
NUMBER is the correct datatype?), there is data in the tables, the
biomart user Im connecting with has appropriate privileges and it
should work - at least based on my experience with MySQL versions.
When I connect to the database using marteditor (v4) I get this message:
"No datasets available, is this a biomart compatible schema"
The tables on my MySQL version are essentially the same but all lower
case and they worked fine.
Let me know if anyone can see anything obvious that could be causing
the problems
Thanks in advance!
Simon.
--
Simon N. Twigger, Ph.D.
Assistant Professor, Department of Physiology
Medical College of Wisconsin
8701 Watertown Plank Road,
Milwaukee, WI, USA
tel: 414-456-8802
fax: 414-456-6595
AIM/iChat: simontatmcw
On Sep 29, 2006, at 1:51 PM, Arek Kasprzyk wrote:
On 29 Sep 2006, at 18:16, Twigger Simon wrote:
Hi there,
We're moving a mart over to oracle and we've got a main table called:
RGD_GENES__GENES__MAIN
When I try and do the naive setup it cant find a dataset and asks
if this is a biomart compatible schema... The schema used to work
fine on MySQL, I wondering if the case change from
rgd_genes__genes__main is causing the problem? Do Biomart table
and attribute names have to be lowercase, or at least the parts
that biomart is relying on (__main, __dm for tables, _key, etc
for attributes)
Thanks in advance for any thoughts on this.
Simon,
could you describe your table for us?
Also for MEditor to work you need to have at least one entry in
this table.
Could you check that?
a.
Simon.
--
Simon N. Twigger, Ph.D.
Assistant Professor, Department of Physiology
Medical College of Wisconsin
8701 Watertown Plank Road,
Milwaukee, WI, USA
tel: 414-456-8802
fax: 414-456-6595
AIM/iChat: simontatmcw
----------------------------------------------------------------------
---------
Arek Kasprzyk
EMBL-European Bioinformatics Institute.
Wellcome Trust Genome Campus, Hinxton,
Cambridge CB10 1SD, UK.
Tel: +44-(0)1223-494606
Fax: +44-(0)1223-494468
----------------------------------------------------------------------
---------
