User Tools

Site Tools


help:projects

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

help:projects [2011/01/10 20:47] (current)
Line 1: Line 1:
 +[[http://​www.sofastatistics.com/​userguide.php | Contents]]
 +
 +====== Connecting to Databases ======
 +
 +Unlike many statistics programs, in SOFA Statistics you can connect directly to data you have in any supported SQL-type database (currently MS Access, MySQL, MS SQL Server, PostgreSQL, and SQLite).
 +
 +{{:​help:​sofa_dbs.jpg|}}
 +
 +NB if you have data in a spreadsheet or stored as csv see [[:​help:​importing | Importing spreadsheet/​csv data]]
 +
 +To connect to an SQL-type database, SOFA Statistics needs the necessary login details e.g. password. ​ Rather than having to enter these repeatedly, you can store the login details as part of a project configuration. ​ Most typically, you will only be wanting to connect to one database server e.g. MySQL. ​ SOFA Statistics lets you store details for as many as you like e.g. if some of your data is in SQLite and some is in MS Access then you just enter connection login details for both.
 +
 +  - Click on "​Select Project"​
 +  - Click on "​New"​ to configure new project or "​edit"​ to edit an existing project. ​ NB the SOFA default project cannot be edited.\\ {{:​help:​add_new_project.jpg|}}
 +  - Enter the required details. ​ Tip - hovering over text boxes will often suggest a likely value e.g. "​localhost"​ for host.\\ {{:​help:​demo_project_config.jpg|}}
 +  - Click the "​Update"​ button to save your settings\\ The selected project settings are displayed on the main SOFA form\\ {{:​help:​proj_settings_displayed.jpg|}}
 +
 +[[http://​www.sofastatistics.com/​videos.php#​sql_connect |{{:​help:​play_button.gif|}}]] A video is available showing how to connect directly to your SQL data: [[http://​www.sofastatistics.com/​videos.php#​sql_connect | Connecting to your SQL data video]]
 +
 +[[http://​www.sofastatistics.com/​userguide.php | Contents]]
 +
 +[[:home | Wiki]]
  
help/projects.txt ยท Last modified: 2011/01/10 20:47 (external edit)