Alpana Designer allows to access your data by providing a variety of Connection types. Once the appropriate credentials are validated, you will be able to navigate the data structure and retrieve the raw data.

Now, in order to feed your Dashboard with data, you will need to choose what data table from your Connection will become a Data Source.

In a basic workflow, this is enough. However, Alpana Designer lets you compose more complex preparation on your data when needed. For example, you can join tables together, including from multiple Connections, filter data, create Expressions, …

Connections

What is a Connection

The Connection represents how you access the data :

  • the Connection type, e.g. : Wonderware Historian, SQL Server, Excel, …
  • for server-based Connections : the server address
  • for file-based Connections : the file address
  • the necessary credentials : authentication mode, user name, password.

How Connections are managed in Alpana Designer

In Alpana Designer, you can :

Data Sources

What is a Data Source

The Data Source is a representation of your data that you prepared from your created Connection(s). It’s what your Widgets (and your Dashboard) see.

A Data Source can be created by adding one or more element from one or more Connection(s) and joining them together :

  • a data Table
  • a data View
  • a Stored Procedure
  • a Custom Query

On top of that, further data preparation can be made :

How Data Sources are managed in Alpana

In Alpana Designer, you can fully manage and export Data sources.

Last modified: May 10, 2023

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment