Data Odyssey Express. Data sources

Data Sources

http://www.dataodyssey.com

http://express.dataodyssey.com

You should describe data sources before building model templates and analyzing data. Open the data source list clicking \Space\Data sources... Then expand the folder with the required data type to see the list of existing data sources and change the properties, if necessary. Or click New to create a new data source.

The properties of any data source include:

Data source name

A unique data source name. It can contain literals, numbers and the _ symbol. You can't change the name of an existing data source. This field is available for a new data source only.

The DATAMAP data source shown here can't be found on the data source list, but it is created automatically when the program starts.

Data source type

	Microsoft SQL Server database and ODBC access
	Microsoft SQL Server database and IIS access with HTTP + XML
	ORACLE and ODBC access
	MySQL and ODBC access
	Visual FoxPro DBF tables and file-server access
	Visual FoxPro DBC database and file-server access
	Microsoft Access database and file-server access
	DataOdyssey server access using RPC and XML
	DataOdyssey server access using IIS, XML and HTTP

After selecting a data source type the program generates a generic connection string if there is none specified. (Otherwise confirmation will be required to replace a user-defined connection string). You will have only to replace certain elements of the string with the real values (server name, database, directory, IP-address, etc.)

Connection string

A string with special elements in a format necessary to connect to a data source. The format of the string is specific for every data source type. A connection string sample will be shown below the string field and copied to the clipboard after you select a data source type. Read more about data source types and connection strings in the respective chapters of this manual. The list of generic connection strings is the following:

Microsoft SQL Server database and ODBC access	Driver={SQL Server Native Client 10.0}; Server=localhost; Database=master; uid=<app_uid>; pwd=<app_pwd>	Replace "localhost" with a real SQL Server name or an IP-address and "master" with a real database name. !!! Make sure SQL Server Native Client 2008 is installed onto your computer! This driver isn't included into MDAC and operation systems up to Windows 7. You can download driver installation from here (win32) or Microsoft site http://www.microsoft.com/downloads/details.aspx?familyid=228de03f-3b5a-428a-923f-58a033d316e1&displaylang=en !
Microsoft SQL Server Database and IIS access with HTTP + XML	Host;nwind	Replace "Host" with a real host name (IP-address can be used instead) and "nwind" with a real virtual directiory name.
ORACLE and ODBC access	DSN=ORACLE; UID=<app_uid>; PWD=<app_pwd>; DBQ=ORACLE; DBA=W; APA=T; EXC=F; FEN=T; QTO=T; FRC=10; FDL=10; LOB=T; RST=T; GDE=F; FRL=F; BAM=IfAllSuccessful; MTS=F; MDI=F; CSR=F; FWC=F; PFC=10; TLO=0;	Replace "Oracle" with a real server name for "DSN=" and with a real database name for "DBQ="
MySQL and ODBC access	DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=test; USER=<app_uid>; PASSWORD=<app_pwd>; OPTION=3;	Replace "localhost" with a real MySQL server name (IP-address can be used instead) and "master" with a real database name.
Visual FoxPro DBF tables and file-server access		Just specify a directory.
Visual FoxPro DBC database and file-server access		You will need to specify a DBC file.
Microsoft Access database and file-server access	Driver={Microsoft Access Driver (*.mdb)}; dbq=Full_Path\File.mdb; uid=<app_uid>; pwd=<app_pwd>	Replace "Full_Path\File.mdb" with a real MDB file path.
DataOdyssey Express server access using RPC and XML	Host; Datasource	Replace "Host" with a real host name (IP-address can be used instead) of a server with Dataodyssey Express installed and "Datasource" with a data source name, defined using Dataodyssey Express tools on the server.
DataOdyssey server access using IIS, XML and HTTP	Host; Scripts; Datasource	Repalce "Host" with a real host name (IP-address can be used instead) of a server with Dataodyssey Express installed, "Scripts" with a real directory, which contains Foxisapi.dll, and "Datasource" with a data source name, defined using Dataodyssey Express tools on the server.

Preliminary row calculation

This property is aimed at avoiding mission hang when large data is being retrieved. This setting can be defined for every data source individually depending on this data source connection performance. If you select Local Settings, the general settings for all data sources will be applied and they can be changed by clicking \Space\Local settings... on the menu.

If you select Ask if ... the program will preliminary calculate the number of rows retrieved before the retrieval. In case it exceeds the limit, the program will ask to confirm retrieving only the row quantity falling within the limit.

Select No to cancel preliminary row calculation.

! Functions only with simple missions without submissions and joins !

When you click the Save button the program tries to connect to a data source using a composed connection string. If an error occurs, the data source will not be created in the data map (or no changes will be made to an existing data source).