Search Extrata Help by Keyword

Microsoft SQL Server

You are here:
Overview

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet). Extrata downloads your data using the Microsoft SQL Server API.

Skill Level:  Microsoft SQL Server API Classification

Production Status: Live

Microsoft SQL Server
Sample Connection Strings
  • DSN=sql_test;DATABASE=test;UID=test;PWD=testtesttesttest;CHARSET=UTF8
Steps to Configure the Microsoft SQL Server API Service Connector
Steps to Set-up the Source
  1. Click on the “Services” menu link in the left pane.
  2. Click on the “+” next to the Microsoft SQL Server Service.
  3. Enter the Source Name.
  4. Enter the optional Source Description.  Text in the description is useful during search requests.
  5. The Service should already default to “Microsoft SQL Server”.
  6. Enter the Database Name.
  7. Enter the User Name and Password for the user that has credentials to connect to the database.
  8. Enter the host name for the server. (use the server name or IP address)
  9. Enter the port number for the connection.  The default port number for Sql Server is 1433.
  10. Click Save to create the new source.
Steps to Set-up the Task
  1. Click on the “Projects” menu link in the left pane.
  2. If there are no projects listed, create a new project, otherwise go to step 3.
  3. Click on the project name that will contain the task. Click the “Add Task” button.
  4. Enter the Task Name.
  5. Enter the optional Task Description.  Text in the description is useful during search requests.
  6. The Project is where the task will be saved and it will default to the Project name selected from the project list.  If you need to change the project, select the new project from the drop down list.
  7. The Source will default to the source name that is set as the default for the project.  If you need to change the source, select the new source from the drop down list.
  8. Enter the SQL Statement for the query. Example:
    SELECT * FROM [northwind].[dbo].[Customers]
  9. Enter the path or browse to the Save To Folder. The Save To Folder location defaults to the same location you set in your project, but you can also override it.
  10. Enter the file name for the output file.
  11. Select the File Type from the drop down list.  When saved, the file name will end with the selected file type.
  12. Click Save to create the new Task.
Running the Task
  1. Click on the “Projects” menu link in the left pane.
  2. Select the Project that contains the task.
  3. In the Tasks list, click the Run Microsoft SQL Server API Task run icon for the task you would like to run.  The data will be downloaded from your service using the API and saved to the output file location. During the run, a Run Task dialog window will open with a task log of the run.  You can use this log to troubleshoot any run-time issues.
Extrata

Hey, It's Free!

Well, we can't really give a discount on a price of $0.
Go ahead and download Extrata and start getting data from all your services.

Extrata
close-link
Extrata

Purchase New License - Enterprise Pricing Discount

UsersLarge License
1 - 3$99
4 - 10$89
11 - 20$82
21 - 49$75
50$68
close-link
Extrata

Purchase New License - Standard Pricing Discount

UsersMedium License
1 - 3$49
4 - 10$44
11 - 20$41
21 - 49$37
50$34
close-link
Extrata

Purchase New License - Small Pricing Discount

UsersSmall License
1 - 3$29
4 - 10$26
11 - 20$24
21 - 49$22
50$20
close-link