Configuring Database Connections
By default, FactoryStudio uses an embedded SQL database (TatsoftDB) for the tag and alarm historians. You can configure external databases such as Microsoft SQL Server, Oracle, or other external database. If you expect your database to grow to more than 10 GB, you should consider using an external database.
When using the embedded database, the system automatically creates the database file. When using external databases, the database itself must already exist. However, FactoryStudio can create the tables in the database.
You can use also use external databases as a data source in your application to display such things as customer or product information or to configure systems from recipes.
You must be logged in as Administrator in FactoryStudio to configure the database login and password.
To configure an external database:
1. Go to Edit > Datasets > DBs.
2. Click Create New.
•The Create New Database Connection window displays.
3. 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. |
4. Click OK.
•The database is added as a new row in the table.
5. 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. |
Provider | Select the database provider. |
Database | If options display here, select the database type. |
ConnectionString | Enter the information needed to connect to the database. |
LogonName | Enter a valid login name for the database. |
LogonPassword | Enter the password that corresponds to the database login. |
Description | Enter a description for the database. |
[Other columns] | For definitions of other columns that are available in many tables, see Common Column Definitions. |
6. 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.
7. Continue adding as many database configurations as you need.
•The databases you create are available for use on the Tags > Historian tab, in displays, and in scripts.
•If needed, right-click a row to cut, copy, paste, or delete the row.
•See the following sections related to the other Dataset tabs: