Use this screen to configure the connection to Rockwell FactoryTalk SE database and choose the tags you want to export into OPSDATAXML output files.
-
Data Source: This field specifies, in loose terms, the "Database/Datasource server name" where your Rockwell FactoryTalk SE system is configured to store data. For MS SQL this is in the form of host\sql_instance_name.
-
Initial Catalog: This is the name of the database that contains the source data.
-
Database Type: Currently MS SQL and Oracle DBMS' are supported
-
OLE DB Provider: This specifies which "database driver" the interface will use when connecting to the Rockwell FactoryTalk SE database. If connecting to MS SQL 2005 or later, use the native client to connect. Specify SQLNCLI as the provider. NOTE: You will need to have the Microsoft SQL Native Client installed for this to work.
-
Username: The username to connect to the Rockwell FactoryTalk SE database. This user must have the rights to view the database tables that contain the data.
-
Password: The password associated with the Username.
-
Connection Timeout in Seconds: How many seconds the program should wait when establishing a connection to the database before aborting.
-
Command Timeoutin Seconds: Specifies how many seconds the program should wait for a query to complete before aborting the operation.
WARNING: Large values for these two settings can cause the program to not respond for a long period of time! Do NOT use 0 unless you know what you are doing - it will cause the program to wait indefinitely, and if your database server is down, the only way to cancel the operation is to forcefully quit the program.
-
Customizations: This should be left empty unless you were told otherwise by a Hach Support Engineer or you know what you are doing.
- Test Connection: Test to see if the connection settings are valid and the collector is able to connect to WonderWare Historian database. This will NOT Apply or Save the settings.
-
Refresh Settings & Tags: This will load values for the next tab to be configured.
Select Tags - Use this tab to select the tags that will have data collected. You must configure the Source Connection before using this tab.
All Available Tags: This is a list of all the tags that are available in the system that can be collected.
Filtered Tag List: Tags listed here will have thier data collected.
Search Boxes: The search boxes allow you to search the list of tags for a particular string. The search will start from the currently selected tag (or the top if nothing is selected) so you can continue to press the search button to find the next match.
NOTE: If the xml files being produced the by collector do not have data in them, check to make sure the Data Log Models have a storage format of ODBC Database, within FactoryTalk View Studio.
