Search
Related topics are listed below.
Alpana Server
Alpana Server
Alpana Server is a website application that allows to make use of the content created with Alpana Designer : display and interact with visualizations, export, notify, socialize. Securely share your Dashboards and Widgets to any modern web browser. Dashboards can be…
SQL Server
Alpana Designer » Connecting to Data » Connection types » SQL Server
Versions This connector can be used to get data from local or remote Microsoft SQL Server installations with the following versions : Microsoft SQL Server 2012 and later Microsoft SQL Server Express 2012 and later Selecting Connection Type In the “Create…
About Alpana server
Alpana Server » About Alpana server
Alpana Server is a web server that allows to share and manage your Alpana content (Dashboards, Widgets, Data Sources). After creating content in Alpana Designer, you simply push it to Alpana Server. This is called Publishing. Securely share your Dashboards and Widgets…
Login to Alpana Server
Alpana Designer » Dashboard Settings and Publication » Designer-level Settings » Login to Alpana Server
Alpana Designer can log in to Alpana Server. This is useful for importing/exporting objects to Alpana Server from the Alpana Designer interface. Logging in To login, click the profile icon on the top right of the Alpana Designer Window and click Log In : The Login…
Publish a Widget to Alpana Server
Alpana Designer » Configuring a Widget » Export / Import Widgets » Publish a Widget to Alpana Server
*In order to Publish a Widget to Alpana Server, you need to be logged in from Alpana Designer to that Alpana Server, and have the necessary permissions to create Widgets. In the top bar, click Publish : In the “Publish” dialog, fill in details and…
Import a Widget from Alpana Server
Alpana Designer » Configuring a Widget » Export / Import Widgets » Import a Widget from Alpana Server
*In order to Import a published Widget from Alpana Server, you need to be logged in from Alpana Designer to that Alpana Server, and have the necessary permissions to access the Widget. From the Dashboard activity Click on the “Import Widget” button in the…
Publishing a Dashboard to Alpana Server
Alpana Designer » Dashboard Settings and Publication » Create and Export / Import Dashboards » Publishing a Dashboard to Alpana Server
“Publishing” means pushing the Dashboard to a Tenant on Alpana Server to make it available to other users. *In order to Publish a Dashboard to a Tenant on Alpana Server, you need to be logged in from Alpana Designer to that Alpana Server tenant, and have…
Importing a Dashboard from Alpana Server
Alpana Designer » Dashboard Settings and Publication » Create and Export / Import Dashboards » Importing a Dashboard from Alpana Server
*In order to Publish a Dashboard to a Tenant on Alpana Server, you need to be logged in from Alpana Designer to that Alpana Server tenant, and have the necessary permissions to access the Dashboard. Click the top toolbar Open Dashboard button : In the Import…
Login to a Wonderware Historian server
Alpana Designer » Wonderware Historian » Connecting to Wonderware Historian » Login to a Wonderware Historian server
Connection Parameters To login to a Wonderware Historian server, fill-in the following fields : If in the current session you have already connected to a Historian server, you can select it in the combobox below to auto-fill the Host Input. !Important : Because…
Publish a Data Source to Alpana Server
Alpana Designer » Transforming Data » Export / Import Data Sources » Publish a Data Source to Alpana Server
*In order to Publish a Data Source to Alpana Server, you need to be logged in from Alpana Designer to that Alpana Server, and have the necessary permissions to create Data Sources. In the top bar, click Publish : In the “Publish” dialog, fill in…
Import a Data Source from Alpana Server
Alpana Designer » Transforming Data » Export / Import Data Sources » Import a Data Source from Alpana Server
*In order to Import a published Data Source from Alpana Server, you need to be logged in from Alpana Designer to that Alpana Server, and have the necessary permissions to access the Data Source. Click on the “Import” button in the Data Sources list : …
Installing
Alpana Server » Installation » Installing
Important !Before installing, make sure you meet the Pre-Requisites. *Alpana Server will create folders and SQL databases. Download installer See here to download the installer. Running the Alpana Server installer Login with administrator rights to the machine…
Email (SMTP)
Alpana Server » Settings » Email (SMTP)
Alpana can send e-mails to users, and requires to configure the e-mail sending for the following usage : user activation recovering forgotten passwords sending exports through Schedules receiving notifications To manage e-mail settings, go to the Host, in…
Test connection
Alpana Designer » Wonderware Historian » Connecting to Wonderware Historian » Test connection
To test the connection for validity, click Test Connection button. The following message will confirm its validity. If the connection is invalid, an appropriate error message will be displayed instead. Then you will need to fix the Connection parameters…
Settings-Appearence (Use Custom CSS)
Alpana Server » Settings » Settings-Appearence (Use Custom CSS)
You can apply your theme to Alpana Server To do so, please apply the following settings to your server. First, you need to set the White content Skin to your layout by following the steps on the screenshot below by selecting in step 3 the White value in the combo…
Tenant Management
Alpana Server » Tenant Management
Note : For a better understanding of Tenants, you can see the Multitenancy chapter. Tenants are managed at the Host level (that’s the main purpose of the Host). By default, only one Tenant exists and is called Default. To manage Tenants, see the below…
Setup
Alpana Mobile » Installation » Setup
Address At first launch you will be prompted to enter Alpana Sever address. The format of your input should exactly match the address set for your server. For instance, if your server has been set to ignore the “www”, you should ignore them in your…
Upgrading from an older v2 to v3.0
About Alpana » Release Notes » Upgrading from an older v2 to v3.0
Introduction : limits of applicability This procedure only applies if you are upgrading from Alpana Server version number starting with v2 Dashboards migration Notice of incompatibility Due to internal changes for supporting new features, two component from…
Backup
Alpana Server » Maintenance and Migration » Backup
Introduction Two elements of Alpana Server must be backed up : the Alpana Server database, named AlpanaDb by default the dashboards folder located in the installation folder, by default C:\inetpub\alpana3\, inside \app\App_Data\Published\ Backup *To perform a…
IIS Configuration pre-requisite
Alpana Server » Installation » Pre-Requisites » IIS Configuration pre-requisite
Required IIS configuration !Pre-requisites order is very important. If you modify any IIS setting after installing AspNet Core, then you will have to Repair AspNet Core : see Installation Troubleshooting. In order to install Alpana Server, Microsoft IIS must be…
Installation
Alpana Server » Installation
To install Alpana Server, please follow the below chapters. Pre-Requisites are very important, in particular IIS Configuration.
v3.0.2.x
About Alpana » Release Notes » v3.0.2.x
Release notes of items completed between Alpana v3.0.1.1 and v3.0.2.2 Upgrading Alpana Server install upgrade from v3 To upgrade Alpana Server from v3.0.1.1, first un-install the previous version from Windows Control Panel, as documented here. License upgrade !An…
Post-Installation
Alpana Server » Installation » Post-Installation
The steps required to activate and configure the application after installation are listed below. Startup If you didn’t start the website during the installation procedure, manually start the Alpana3App and Alpana3Client websites from Microsoft IIS Management…
Architecture
Alpana Server » About Alpana server » Architecture
This chapters explains the components of Alpana Server. Alpana Server is a website that deploys on Microsoft IIS and stores data to databases in Microsoft SQL Server. Websites Alpana Server runs two websites on Microsoft IIS : the Back-End Site the Front-End…
Pre-Requisites
Alpana Server » Installation » Pre-Requisites
This section explains the system requirements to run Alpana Server. Software Operating System Windows OS (x64) : Windows Server : 2012 R2, 2016 Windows : 10 (Version 1607+) Database Microsoft SQL Server is required. Microsoft SQL Server Express possible, but…
Dashboard error logs
Alpana Server » Troubleshooting » Dashboard error logs
What errors are logged Published Dashboards and Widgets can generate errors when viewed. Typically, this will show a Data retrieval error message in place of the Widget’s visuals : This means that the Widget was unable to get the required data. These errors…
Upgrading
Alpana Server » Installation » Upgrading
Major upgrades : Upgrading from 3.x to 3.y !Upgrading may require to re-activate your license in some cases. Read below for details. If this is your case, please check beforehand that you will have a the ability to activate, otherwise your Alpana Server installation…
License Activation
Alpana Server » License Management » License Activation
Browsing your license portal Login to the web License Portal. Navigate to Licenses & Activations : Under Licenses & Activations, click the License ID you want to activate : Important note !Before starting the license activation, please make sure that you have…
Login
Alpana Mobile » Usage » Login
Login screen The login screen allows you to enter your login credentials. From there, you can also change the tenancy name and reset the server address. Login behavior After your fist connection, the application will securely save your credentials and will…
Buffer database setup
Alpana Designer » Connecting to Data » The data Buffer » Buffer database setup
In Alpana v3.0.0, the Buffer database is setup automatically : for the Alpana Server : this setting applies to published Dashboards. A Microsoft SQL database is created by Alpana Server to host the buffer tables. for each Alpana Designer installation : this setting…
Installation Troubleshooting
Alpana Server » Troubleshooting » Installation Troubleshooting
Generating install logs In some cases, the installation of Alpana Server may fail and roll back the changes. To get more information, you can start the installer with error output by following the below procedure. Start cmd Run Windows command prompt…
Components of the application
About Alpana » Components of the application
Alpana Platform is composed of : Alpana Designer : the development tool for creating Data Sources, Widgets, Dashboards Alpana Server : the website deployed for sharing content Alpana Mobile : the mobile app used for viewing on mobile devices Alpana Update File…
Website Troubleshooting
Alpana Server » Troubleshooting » Website Troubleshooting
Below are some useful resources and some answers to common issues with reaching or starting the websites. Useful logs IIS Requests Logs If you need to investigate your network configuration to see the content of HTTP requests, you can find IIS log files : 1. Open…
General API help and troubleshooting
Alpana Server » API » General API help and troubleshooting
Permissions To work with the API, the user must have the required permissions on the Tenant : API permissions desired object permissions : for example, for API queries on Schedules, the user must have permissions on Schedules API location The API responds on the…
Un-Installing
Alpana Server » Installation » Un-Installing
Tips Don’t lose your license ! Before un-installing, perform a license de-activation in order to be able to re-use your license later. Avoid a reboot If you don’t stop the application, Windows will probably require you to reboot. If you don’t want…
User Settings
Alpana Server » Settings » User Settings
As administrator of the Host or of a Tenant, you can configure user account and login features on a global level. To manage user account and login features of a Host or Tenant, go to the corresponding Administration > Settings and browse to the tabs User management…
Multitenancy
Alpana Server » About Alpana server » Multitenancy
Alpana Server is a multi-Tenant application. This means that a single instance of Alpana Server can manage any number of customer-facing isolated instances. What Is Multi-Tenancy? The term “software multitenancy” refers to a software architecture in…
Migration
Alpana Server » Maintenance and Migration » Migration
Purpose Case 1 : Development → Staging → Production You have several environments for your development cycle. When development has been tested on one environment, you want to migrate the content (dashboards, users, etc) towards the Production environment. Case 2…
API
Alpana Server » API
Alpana Server exposes a web API that exposes many actions and properties. The following chapters document how to use this API.
Connecting to Wonderware Historian
Alpana Designer » Wonderware Historian » Connecting to Wonderware Historian
As with other Connection types, connecting to Wonderware Historian means defining how Alpana will find the data : what is the server address and what is the login. See the following chapters for detailed information.
License Management
Alpana Server » License Management
License is managed at the Host level for all Tenants. Login to the Host of your Alpana Server and navigate to Administration > Settings, tab License Management. See the below chapters to manage your license.
Wonderware Historian query result
Alpana Designer » Wonderware Historian » Wonderware Historian query result
After configuring the query, Alpana is able to send it to the Wonderware Historian server and get the result. This result will be modeled as a Table inside the current Data Source. For details about the schema and data of this query result, see the next…
Widget Auto-refresh
Alpana Designer » Dashboard Settings and Publication » Dashboard-level Settings » Widget Auto-refresh
What is Auto-Refresh At runtime, when the Dashboard loads in the browser, data is fetched from the data sources and Widgets are drawn. After this, if the user doesn’t interact with the Dashboard, no new data is fetched and the data displayed can become…
Alpana Designer
Alpana Designer
Alpana Designer is used to create the content of Alpana (Widgets, Dashboards, Data Sources). Drag and drop widgets into the interface and manipulate your data right away. The desktop application allows you full autonomy. Once the Dashboard ready, share with your…
Alpana data model
Alpana Designer » Connecting to Data » Alpana data model
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…
Language
Alpana Designer » Transforming Data » Custom Query Tables » Language
When connecting directly to a database, the language of the Custom Query must be compatible with the database. When connecting to a bufferized Connection, the Custom Query must be written in the language used by the Buffer database. !Important When changing the…
Dashboard Page
Alpana Mobile » Usage » Dashboard Page
Once logged in, the application navigate you to the dashboard page. Here, you can browse through all the dashboard saved into your server. This page is divided into five different tabs in appearing order: Favorites Recent Categories Public All The dashboard…
Excel
Alpana Designer » Connecting to Data » Connection types » Excel
Formats You can connect to Microsoft Excel workbooks in format *.xlsx or *.xls containing “database-like” tabular data. The Excel workbook should have column names at first row of sheets followed by data rows. The data type of all values in a column…
Important pre-requisite
Alpana Designer » Wonderware Historian » Connecting to Wonderware Historian » Important pre-requisite
!Important If you connect to a fresh install of Wonderware Historian Server, tags may not be available for browsing. Starting Historian clients once In order to make tags available for browsing, you will have to startup Wonderware Historian Client Query or Wonderware…
License Deactivation
Alpana Server » License Management » License Deactivation
Why Deactivate You may want to return the license from a Host in order to decommission the Host and use the license on another Host. For example, before moving the installation to a new hardware, you must de-activate. Note of warning Deactivate is not the same as…
CSV
Alpana Designer » Connecting to Data » Connection types » CSV
Formats Although “CSV” means “Comma-Separated Values”, Alpana supports other separators than comma : Comma : “ , “ Semicolon : “ ; “ Space : “ “ Tab : “ “ Selecting…
Tenancy
Alpana Mobile » Usage » Tenancy
Single tenancy In the case of single tenancy, the application will try to set “Default” as tenancy name at first launch as is it the default tenant in the Alpana solution. If your company changed the “Default” name for something else you will…
The data Buffer
Alpana Designer » Connecting to Data » The data Buffer
Introduction : What is the Buffer ? The primary source for data in Alpana is a database (SQL Server, Oracle). When a Dashboard requires data from a Data Source that is based only on database Connections, the query is composed by Alpana and executed directly on the…
Dashboard Preview
Alpana Designer » Dashboard Settings and Publication » Dashboard Preview
When working in Alpana Designer, you can easily preview your work in the Dashboard Preview. *This is useful for testing interactions and making sure the dashboard layout is correct before Publishing. This Dashboard Preview is local, so you don’t need access to…
Data Flow : How bufferization happens ?
Alpana Designer » Connecting to Data » The data Buffer » Data Flow : How bufferization happens ?
Data flow When data is requested from a bufferized Connection, the following happens : If Buffer Refresh is not enabled : data is retrieved from the buffer. If Buffer Refresh is enabled : If the buffer is valid ⇒ data is retrieved from the buffer. If the…
Pre-Requisites
Alpana Designer » Installation » Pre-Requisites
This section explains the system requirements to run Alpana Designer. Hardware Requirements The following minimum hardware requirements are necessary to run Alpana Designer, but more is better for bigger projects : Processor : Dual Core 32-bit CPU (x86) Hard disk…
Creating a Tenant
Alpana Server » Tenant Management » Creating a Tenant
*By default, 1 Tenant is already created after installing. It is called Default. To create a Tenant, click Create new tenant : This opens the Create new tenant dialog_ : Fill-in the required information : Tenancy name / Tenant name : the name of the…
Creating Categories
Alpana Server » Categories Management » Creating Categories
*When you install Alpana Server or create a new Tenant, no Categories exist by default. You will need to create at least one Category for publishing. Categories are managed like a tree of folders. There are two types of Categories : root Categories are at the root…
v3.0.1.x
About Alpana » Release Notes » v3.0.1.x
Release notes of items completed between Alpana v2.0.8.12 and v3.0.1.1 Upgrading Upgrading from v2 to v3.0 requires manual steps. Please read these steps and incompatibilities in the full chapter about Upgrading. Main Features Some main features in a few words…
API Origins Whitelist
Alpana Server » Settings » API Origins Whitelist
Why Querying or embedding a content from Alpana into another website requires to be allowed from Alpana. This is called Cross-origin resource sharing , see also Same-origin policy. If you fail to do so, you won’t be able to query or embed Alpana content from…
Measure Formatting and Date Formatting
Alpana Designer » Configuring a Widget » General Widget Properties » Measure Formatting and Date Formatting
Introduction Most Widgets show data labels for values and dates, which may depend on user culture and personal choices. The properties panel has a “Format” section which allows to configure these labels. All number and date fields are listed there, and…