UNDER DEVELOPMENT
OCTOBOARD
Nederlands
PRIJS
INLOGGEN
START OCTOBOARD GRATIS
START OCTOBOARD GRATIS
Nederlands

GEAUTOMATISEERDE RAPPORTAGE TEMPLATES

Selecteer een template en genereer automatisch rapporten met onze rapporteringstools voor verkoop, financiën, SEO en PPC of creëer online marketingdashboards.
ALLE DASHBOARDS TONEN
HOME / DASHBOARDS / SQL SERVER

SQL SERVER DASHBOARD

Microsoft SQL Server database connection.

Octoboard data dashboard: Microsoft sql server database dashboard in octoboard
Use this Miscrosoft SQL Server database connection to add historical data widgets, pie charts and numeric widgets to Octoboard business performance dashboards, automated reports and white label client portals.

For more details on how to connect your database to Octoboard please visit this Knowledge Base post.
Notities
Please use standard Microsoft SQL Server connection parameters - database name, host name, ip address, port, login details and security settings.
251
PROBEER HET NU
Laatst bekeken op:
18-Mar-21
Dashboards:
Rapporten:
Clientportals:
White-label:
Data vernieuwen:
Data-inzichten:
Output kantoor-tv:
Meerdere klanten:

SQL SERVER STATISTIEKEN

NUMERIEKE SQL-SERVER

Microsoft SQL Server Numeric widget
Beschrijving
This widget displays a single numeric value. SQL statement should return a single column. The very first value will be read and displayed in the widget. In the following example, SQL statement returns population of USA:

SELECT population FROM countries WHERE country="USA"
GEBRUIK DIT CIJFER

CATEGORIE SQL-SERVER

Microsoft SQL Server Category data widget
Beschrijving
Category widget displays values in tables or pie charts. SQL statement should return two columns. First column should contain category name, second column should return numeric values.

In the following example, SQL statement retrieves country names and country population. Pie chart will display countries ranked by population size:

SELECT country, population FROM countries
GEBRUIK DIT CIJFER

HISTORISCHE SQL-SERVER

Microsoft SQL Server Historical data widget
Beschrijving
Historical data widget displays historical data in a column, line or area graph. SQL statement is expected to return two columns. The first column should have dates, second one should have values.

In the following example, SQL statement retrieves shares price for Apple.

SELECT date, price FROM stock WHERE ticker="AAPL"


Make sure you sort results by date. Sequence of returned data raws is important. The platform will display first 1000 rows that it retrieves.
GEBRUIK DIT CIJFER
ABONNEER U OP ONZE NIEUWSBRIEFWe bouwen dashboards voor social media en bedrijven en platforms voor data-analyse. Wees er als eerste bij, zonder te worden overladen met e-mailupdates.
Sociogram - LinkedInSociogram - FacebookSociogram - TwitterSociogram - VKontakteSociogram - PinterestSociogram - Instagram
Octoboard - Data voor uw businessOcto Ltd Logo