Extrata Blog

Search Extrata Help by Keyword

SQLite

Overview

SQLite is a relational database management system contained in a C programming library. In contrast to many other database management systems, SQLite is not a client–server database engine. Rather, it is embedded into the end program. Extrata downloads SQLite data using the SQLite API.

SQLite is ACID-compliant and implements most of the SQL standard, using a dynamically and weakly typed SQL syntax that does not guarantee the domain integrity.

SQLite is a popular choice as embedded database software for local/client storage in application software such as web browsers. It is arguably the most widely deployed database engine, as it is used today by several widespread browsers, operating systems, and embedded systems (such as mobile phones), among others. SQLite has bindings to many programming languages.

Skill Level:  SQLite API Intermediate Classification

Production Status: Live

Steps to Configure the SQLite 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 “SQLite”.
  6. Enter the path or broowse to the database. Example:  …\sqlite\ex1.db
  7. 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 tbl1;
  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 SQLite 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