Page History

...

• Go to Edit > Datasets > DBs.
• Click Create New. The Create New Database Connection window displays.

• Enter or select information, as needed.

  Column	Description
  Name	Enter a name for the database configuration. The system lets you know if the name is not valid.
  Description	Enter a description for the database.
  Provider	Select the database provider.
  Database	If options display here, select the database type.

  
  

• Click OK.
• The database is added as a new row in the table.
• Enter or select information, as needed.

• If you are using the new external database for the alarm or tag historian, rename the existing TagHistorian or AlarmHistorian database to something else, then rename the new database configuration to TagHistorian or AlarmHistorian. For the tag or alarm historian databases, the database configuration on this tab must be named TagHistorian or AlarmHistorian. You cannot have two databases with the same name.
• Continue adding as many database configurations as you need.

...

• Go to Edit > Datasets > Tables.

• Enter or select information, as needed.

  Column	Description
  Name	Enter a name for the table configuration. The system lets you know if the name is not valid.
  DB	Select the database configuration.
  TableName	Select the table name.
  WhereCondition	Specify parameters to filter the data using SQL syntax. E.g. "ColumnName = {@tag.tagInt}"
  Access	Select the access permissions for the table.
  Mapping	Click ... to select the tags that you want to populate with data from the first row of the table with data from specific columns.
  MappingDateTime	Select the time reference: UTC or Local.
  Description	Enter a description for the table configuration.
  <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="35328f88-c5db-4d94-881c-e688b5f9cab8"><ac:plain-text-body><![CDATA[	[Other columns]	For definitions of other columns that are available in many tables, see "Common Column Definitions".	]]></ac:plain-text-body></ac:structured-macro>

  
  

• Continue adding as many table configurations as you need.

...

• Go to Edit > Datasets > Queries.

• Enter or select information, as needed.

  Column	Description
  Name	Enter a name for the query. The system lets you know if the name is not valid.
  DB	Select the database configuration.
  SqlStatement	Enter the query using SQL syntax.
  Mapping	Click ... to select the tags that you want to populate with data from specific columns returned by the query.
  Description	Enter a description for the table configuration.
  <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="e3e0bf4d-f619-4dca-aa5e-8bc6d73c3bff"><ac:plain-text-body><![CDATA[	[Other columns]	For definitions of other columns that are available in many tables, see "Common Column Definitions"	]]></ac:plain-text-body></ac:structured-macro>

  
  

• Continue adding as many queries as you need.

...

• Go to Edit > Datasets > Files.

• Enter or select information, as needed.

  Column	Description
  Name	Enter a name for the file configuration. The system lets you know if the name is not valid.
  FileName	Enter the full path to the file.
  FileType	Select the type of file.
  Objects	Click ... to select the tags that you want to populate with data from the file with data from specific columns.
  Description	Enter a description for the file configuration.
  XMLSchemaType	Represents the schema type of an XML file, which can be: TagList: XML containing a tag list with tag name and tag value TagObject: XML containing the entire tag tree and its children
  <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="8e1c4195-4ebd-44ec-b266-1c3966adc12a"><ac:plain-text-body><![CDATA[	[Other columns]	For definitions of other columns that are available in many tables, see "Common Column Definitions" on page 54.	]]></ac:plain-text-body></ac:structured-macro>

  
  

• Continue adding as many file configurations as you need.

...