Any Data, Any Location, Any Format
The SEURAT philosophy is one of "Data Inclusivity". Include the data, whatever the form or location. With respect to databases, this means SEURAT will hook up to any data warehouse, data mart or operational database.
SEURAT brings together all of your data, no matter where or how it is stored, into one easy to use application
- Therapeutic database vendor agnostic (Abase, MDL ISIS, Cambridgesoft, Accelrys...)
- Public and commercial database aware (WDI, MDDR, PubChem, MDL Patent, CrossFire, Aureus...)
- Computational tool agnostic (PipelinePilot, ChemAxon, MOE, ACDLabs, Strand Life Sciences...)
- PK, DMPK and Tox databases (IDBS BioBook, BioRails, Derwin, Topkat...)
- Computational and modelling results at your fingertips (crystal structure, SDF, Excel, CSV...)
- Genomic and sequence databases, Mass Spec
- Compound Vendor agnostic search with chemical flag generation (IFLabs, Enamine...)
- External / 3rd party databases WOMBAT, MDL Patent, MDL CrossFile BeilStein, Aureus GPCR and Kinase data
- Public data / databases WDI, MDDRfrom Pubchem
- Compound Vendor databases like IFLabs, Enamine etc.
- Computational Data Sources like PipelinePilot, MOE, ACDLabs, ChemAxon property calculators, Strand Life Sciences etc.
- Modelling Data Sources containing crystal structure data in standard formats
- Flat files in SDF, Excel, CSV, ... Formats
Have Multiple Databases? No Problem.
SEURAT is designed from the ground-up for a multi-database, multi-schema environment. Simply map each new database and you can search information for one, some or all databases as well as see what kind of information is available in each. SEURAT is flexible enough to accommodate multiple databases including ones from different vendors and each with its own database schema.
Have Databases from Different Vendors? No Problem.
SEURAT uses the open Java Database Connectivity framework, meaning it can talk to any database. What's more, it can simultaneously use multiple databases from the same or different vendors. For example, you can configure SEURAT to use Oracle, MySQL, and PostgreSQL databases simultaneously.
Have Different Databases Schemas? No Problem.
All you need to do is tell SEURAT (through its "meta-data" mapping file) which tables and columns of your database contain representations of the entities Project, Compound, Structure, Lot, Sample, Assay Results, Notebook and Scientist and how to navigate from one table to the next and SEURAT will do the rest.
Deployed SEURAT, then got New Database Tables? No Problem.
You can add access to the data in new database tables after you have deployed SEURAT at your site by adding configuration information.
Work with CROs? No Problem.
Do you work with partners or CROs who are providing flat files, using different databases & schemas, and even using different identifiers? You can make partner data (WDI, compound vendors, Kinase and GPCR databasesÂ…) both structure searchable and available to your researchers right alongside your corporate compounds by:
- Configuring SEURAT to access CRO databases directly
- Loading CRO data into one or more existing SEURAT native databases (running in Oracle, PostgreSQL or MySQL) from SD and CSV files