SQL Database in Factory talk view

Hello guys, Good evening to all, i need a help from you guys.. I'm using AB's factory talk view, how i can create the SQL database to produce the historical data.... Please guys it's urgent....

jillgeorge18 said:

Hello guys, Good evening to all, i need a help from you guys.. I'm using AB's factory talk view, how i can create the SQL database to produce the historical data.... Please guys it's urgent....

Click to expand...

You need a copy of SQL, SQL Server Express will do as a starter package.
You'll need to setup an ODBC connection to said SQL server from the SCADA package and you'll need an account in SQL that has permission to alter tables and/or create databases. If you are connecting to a shared SQL server, I would find a DBA for that server and enlist their assistance.

This manual http://literature.rockwellautomation.com/idc/groups/literature/documents/um/viewse-um006_-en-e.pdf around page 590 should get you started.

Thanks Dravik for your kind information. May i know how to create odbc connection from scada to sql server.