About the Symyx Connector

• Features

• Security

• Limitations

• Metadata

Features

• Indexes experiments stored in the BioVia Workbook repositories.

• Returns experiment metadata along with content from several types of Document Sections.

• Connects to an Oracle database to retrieve experiment data.

• Uses a default query to return item metadata, but a custom query can be provided to return more complex metadata.

• The source system Your Source System is the repository where your data is stored (data to be indexed). This repository is managed by applications such as: - SharePoint O365 - SharePoint 2013/16/19 - Documentum - File Share - OpenText - Lotus Notes - etc. Your Source System repository can also be a database such as SQL or Oracle. retains the master information: the search index Contains data from your source system. Your search application instance (Elasticsearch, SharePoint Online, etc.) contains the search indexes. One search index per content source. provides only a representation (pointer).

Security

• Security information is not retrieved.

• All items are marked as Public.

Limitations

• The Symyx Connector only supports Oracle database connections.

• An experiment is split into sections. Data is only retrieved by default for the following section types:

  • Materials Section

  • Text Section

  • External File Section

  • Spreadsheet Section

• If data from Form Sections should be returned then a new item metadata query should be provided in the connection Connection defines the how Connectivity Hub connects to your Source System (which contains your documents, graphics, etc.,). Your Connection includes identifying elements such as: URL of the BA Insight web service connector you are using, (File Share connector, SharePoint Online connector, etc.), Authentication mode, User Accounts and Credentials, Database information (for database connectors) configuration. This query should query both the VaultObject view and the custom view corresponding to the Form Section.

• Enumeration filters can only be applied to the VaultObject view.

• Because Symyx does not provide a web UI, items do not have individual URLs that can be returned as metadata. If URL metadata is needed then a custom page to render the results will need to be used and the item URL needs to be scripted in the Connection configuration page. Unless a custom page is provided the default value "http://myserver/[itemId]" will be returned in place of the item URL.

• The Symyx connector only supports Oracle as the Database engine to connect to and return experiment data.

• The Symyx connector is not compatible with any version of the Connector Framework, it is only compatible with Connectivity Hub 3.0 and later.

Metadata

• All fields specified in the item metadata query are returned as metadata.

• You must run a Datastore Types Load Collects the types of data from your source system. Runs on a set schedule. Requires a log level which logs information task to pick up changes made to the item metadata query.

• The following columns from the VaultObject view should always be included in the item metadata query

Metadata Property	Value Type	Description
VAULTID	String	The ID of the experiment
TITLE	String	The title of the experiment
LASTMODIFICATIONDATE	DATE	The date and time the experiment was last modified
AUTONAME	String	The autoname assigned to the experiment at creation time

Other metadata that is returned:

Metadata Property	Value Type	Description
Materials	String multivalue	A list of Materials used by the experiment
Preparations	String multivalue	A list of Preparations used by the experiment
TextSection_Names	String multivalue	The names of all the Text Sections found in the experiment
TextSection_Contents	String multivalue	The contents of all the Text Sections found in the experiment