Data source connection and connection types

Applies to Infiniti v8.0 or later
 

How to Connect a Data Source in ‘Manage’

1. Open the Data Source tab in ‘Manage’ and click the ‘New Data Source’ button

 

 

2. Enter the ‘Data Source Name’ in the textbox given, select the ‘Connection Type’ from the drop-down list and enter the ‘Connection String’ for the specified ‘Connection Type’. For more information, refer to Data Source Connection Types below:

 

 

 

3. Click the ‘Test Connection Button’ to check whether the connection has been established:

 

 

 

4. Click ‘Save’ button.

Data Source Connection Types

Infiniti uses connection strings to establish a connection to an external data system. There are several data sources from which the data can be can be read and used by Infiniti – CSV, ODBC, OLEDB, Oracle, Web Service, XML, InfinitiRSS Feed
 

CSV

The CSV connection type enable the connection to a CSV (.csv) or Text (.txt) file. The format for the connection string is:

csv = data-source-path; fields = field-name1, field-name2,….; hdr = header-row-number; delimiter = delimiter-character; skipheaderrows = number; skipfooterrows= number; widths = width-of-field-1, width-of-field-2,….;

Connection String Parameters Description

csv

Path to the text or csv file

fields

Names of the fields in the order they appear in the file.

Hdr

Specifies the row which is to be considered as the header to retrieve the names of each columns

widths

Sets column widths if the text file data source has a fixed width format. Use -1 for a variable width data source

delimiter

Set a custom field delimiter. When this value is not supplied the default comma delimiter will be used.

skipheaderrows

If the text file contains header rows that need to be skipped. State the number of rows to ignore from the top of the CSV file.

skipfooterrows

If the text file contains footer rows that need to be skipped.

The parameters csv and fields/hdr are mandatory and the remaining are optional in a csv connection string.


Example Connection Strings:
  • csv=c:\temp\book1.csv;fields=Name,CategoryId;hdr=1;delimiter=|
  • csv=c:\temp\book1.txt;fields=Name,CategoryId;widths=10,5
  • csv=c:\temp\book1.csv;fields=Name,CategoryId;skipheaderrows=2;skipfooterrows=2


Example CSV with header and footer rows:

----------------------------------------------------------------------------------------------
CLIENT REPORT 01-01-2012
ID,fName,surnam
01,Ben,Smit
03,Sally,Jon
END OF FILE
----------------------------------------------------------------------------------------------

 

In recent versions, if the hdr=1 (e.g. first row is header row) attribute is part of the connection string, the field names will be picked up from the txt file and the 'fields' attribute can be left out.

ODBC

The ODBC connection type enable the connection to data sources such as Access Databases *.accdb, *.mdb etc. The format for the connection string is:

 Driver= {driver-used}; Dbq=data-source-path;

Connection String Parameters Description

Driver

Specifies the Microsoft Access Driver that has been used

Dbq

Specifies the path of the data source


Example Connection Strings:

  • Driver= {Microsoft Access Driver (*.mdb, *.accdb)}; Dbq=C:\_temp\test.accdb;

 

OLEDB

The OLEDB connection type enable the connection to which only support web authentication data sources such as SQL server data sources. The format for the connection string is:

 Provider=provider-name;Persist Security Info=True/False;User ID=user-ID;Initial Catalog=SQL-Database-name;Data Source=server-name;password=login-password

Connection String Parameters Description

Provider

Specifies the Database provider

Security Info

 

User ID

Login ID

Password

Login Password

Data Source

The server name

Initial Catalog

The SQL database name


Example Connection Strings:

  • Provider=SQLOLEDB.1;Persist Security Info=False;User ID=infinitiID;Initial Catalog=Sample Data;Data Source=intelledoxXYZ;password=infinitipassword

 OLEDB connections usually require a username and password, these credentials can be part of the connection string or more securely, the user name and password fields can be used on the data source screen properties hiding the password from plain view.


Oracle

The Oracle connection type enables the connection to an Oracle data sources. The format for the connection string is:

 Provider=Oracle-Provider;Password=infiniti-password;Persist Security Info=True/False; User ID=user-ID;Data Source=Oracle-Database-Name

Connection String Parameters Description

Provider

Specifies the Oracle Database provider

Security Info

 

User ID

Login ID

Password

Login Password

Data Source

The server name

 

Example Connection Strings:

  • Provider=OraOLEDB.Oracle.1;Password=infinitipassword;Persist Security Info=True;User ID=infinitiXYZ;Data Source=orcdb1

Web Service

The Web Service connection type enables the connection to web services which allows users to access the attributes of a function. The format for the connection string is:

http://webservice link


Example Connection Strings:

  • http://intelledoxXYZ/sampledata/service1.asmx

XML

The ODBC connection type enable the connection to an XML data source. The format for the connection string is:

xsd=xsd-file-path; xml=xml-file-path;

Connection String Parameters Description

xsd

Path to the xsd file

xml

Path to the xml file

 

Example Connection Strings:

  • xsd=C:\temp\Books.xsd; xml=C:\temp\Books.xml;

Infiniti

The Infiniti connection type enables the connection to the internal Infiniti data source that the instance of Infiniti is currently using. A connection string is not required for this data source type as this is already known.

Infiniti Datasource type

 

RSS Feed

The RSS Feed connection type enables the connection to an RSS Feed. The connection string must be a URL that points to the RSS feed, usually an XML file. The format for the connection string is a URL, as below.

 Example Connection Strings:
  • http://intelledox.com

 

Related Articles

 

Keywords

rss feed data source connection new source string datasource