the Data Source parameter is part of the URL format in the PI JDBC connection string (specifically part of the OLEDB connection string). See below:
The URL string is specified in the JDBC client code. The Data Source should have the name of a pre-existing PI or AF Server that the JDBC client would try to connect to. Are you getting a particular error? Can you share the code snippet or connection string?
Thanks for your quick response.
I am having a trouble understanding the terms PI server, AF server. Which is to be used and when
I see name "WIN-R1D2AQ081D" when i access from PI System management tools. Is this my data source name
Could i write url as "jdbc:pisql://WIN-R1D2AQ081D/Data Source=WIN-R1D2AQ081D; Integrated Security=SSPI;"
Any and all help is much appreciated
Yes that URL should be correct. If there are no other issues, then the connection should be successful.
The PI Server is what you connect to in PI System Management tools. It is the "time-series" database or historian that contains the data for PI Points or tags. The AF server contextualizes the information into a hierarchical structure.
The Learning channel on Youtube has good high-level overview of the PI System infrastructure so it may be worth looking.
The Master PI section in PI Square may also help in introducing some of the terminology and basics.
The most confusing part about PI Terminology would be (in my opinion) the difference between "PI Server" and "PI Data Archive". Sometimes, these terms are used interchangeably by some people and sometimes, they mean different things. Like in Barry's post, he is referring to the PI Data Archive as the PI Server. However, there is another meaning for the PI Server which is used to refer to a suite of products. Some relevant information below:
The PI Data Archive is a component of the PI Server that performs real-time data collection, archiving, and distribution. For the past 30 years, the PI Data Archive has been referred to as the "PI Server" but because the PI Server itself has incorporated so many new capabilities, including data modeling and analytics, it is now much more than just a data archive!
At present, we normally use this definition:
The PI Server is the heart of the PI System. It collects, stores, and organizes data from all your data sources, providing a powerful and flexible information infrastructure for your organization. The PI Server also includes sophisticated tools for analytics, alerts, and auditing. You can connect the PI Server to almost any existing automation, lab, or information system. Operators, engineers, managers, and other plant personnel use a variety of client applications to connect to the PI Server to view data stored in the PI Server or in external data archive systems. The PI Server is a suite of products.