Rockwell Automation FactoryTalk Historian SE ProcessBook 3.2 User Guide - Manual (Page 293)

7
●
Data Streams
●
●
●
●
●
275
Configure the ODBC Data Source
Once any necessary ODBC drivers are installed, you need to configure the
ODBC data sources available to the computer.
1. Open the ODBC Data Source Administrator (page 273) dialog box.
2. In the User DSN tab, under User Data Sources, click the name of the
ODBC data source you plan to use and then click Configure. The
Setup dialog box for the data source you selected appears.
3. Add the ODBC data source.
Click the Help button, if necessary, and follow Microsoft's instructions
for completing the dialog box.
4. When you have completed configuring the data source, click OK to
return to the Microsoft ODBC Data Source Administrator dialog
box.
To create data sources for any user of the computer, use the System
DSN tab instead of the User DSN tab. You can set up data sources on the
System DSN tab that are available to all users on the computer, but you must
have elevated permissions on the computer.
Use MSQuery to Build Data Sets
You can use Microsoft Query (MS Query) for writing queries. It is not
distributed with FactoryTalk Historian ProcessBook, but if you click the
Design button in the ODBC Data dialog box, then FactoryTalk Historian
ProcessBook searches the registry in your computer to locate
MSQry32.exe when the ODBC data sets dialog box is opened.
The MS Query application does not work with an ODBC query that includes
placeholders. Consequently, the Design button in the ODBC Data dialog box may
be disabled.