REQUEST DEMO
Contact us
en
English
Dansk
Deutsch
Ελληνικά
Español
Italiano
Português
en
en
da
de
el
es
it
pt
Community
>
Documentation
Data Service
About
Getting Started
The Cubes Tab
The Data Source tab
Data Sources
Azure Data Market
CSV
Date Time
DB2
Directory
Ebay
European Central Bank
Excel
Google Analytics
Google Big Query
Google Trends
HTML Tables
Import.io
JSON
Microsoft Office Access
MongoDB
MySQL
OData
Oracle
PostgreSQL
Python
Quandl
R Language
Salesforce.com
Search Metrics
SharePoint
SQL Server
SQL Server Stored Procedure
Statistics Denmark
TARGIT Analysis
Twitter
Weather
Windows Event Log
Wine.com
Cubes
Working With Data Sources
Sharing your data sources or cubes
Formats
Rows
Column properties
Destination Type
Advanced Settings
Formulas
Date & Time
Dynamic
Logical
Math & Trig
Statistical
Text
Installation
Installing Data Service
Configuring Network Security
SQL Server Stored Procedure
This data source is unique in behavior as it is a dynamic data source which will be repopulated every time a selection is made within the TARGIT application.
Name
Specify the name for the data source
Server
Enter the hostname of the SQL Server
Use Windows Authentication
Specifies that TARGIT Data Service will connect with the service credentials. If this box is unchecked you will be asked to enter credentials for SQL Server Standard Edition.
User name
- Enter the username when using SQL Server standard authentication.
Password
- Enter the username when using SQL Server standard authentication.
Database
Select the database where the stored procedure exists
Stored Procedure
Choose the stored procedure on the server
After choosing the stored procedure a list of parameter names will be shown. To configure this you will have to enter the correct parameters for the Stored procedure to run and return a data set for detection the return results.
Metadata
The metadata can be toggled from automatic to manual.
When manual is chosen you will have to add the returned columns by name and specifying the datatype.