Hi Liisa,
What you need is definitely possible. All you need to do is to setup
exportable and importable pair using MartEditor. Please have a look at
exportable and importable pair e.g pdb_id in the following two marts,
msd
and
uniprot
You can view the settings through martEditor using the following
credentials:
MSD MART
databaseType: mysql
host: martdb.ebi.ac.uk
port: 3306
database: msd_mart_4
schema: msd_mart_4
user: anonymous
pass: <leave it blank>
UNIPROT MART
databaseType: mysql
host: martdb.ebi.ac.uk
port: 3306
database: uniprot_mart_17
schema: uniprot_mart_17
user: anonymous
pass: <leave it blank>
Once you establish your exp/imp pair, run Export, and reconfigure perl
bin/configure.pl...... the linking should work when restart the server.
Hope this helps,
Syed
Liisa Koski wrote:
Hello,
I have two datasets that I want to link. Both are main tables. They do
not have similar keys but do contain a common column 'probe_name'.
Dataset A looks something like:
datasetA_id_key
probe_name
sequence
DatasetB looks something like:
datasetB_id_key
probe_name
value
I would like to be able to display the sequence in DatasetA as an
attribute when querying DatasetB.
Is it possible to link them based on 'probe_name'?
How do I set Importable/Exportable using MartEditor?
Thanks in advance for your help,
Liisa
