To Configure the Connection to an External Data Source

1. In the Settings dialog, click Database Connections.

   

2. Click the *New *button.

3. Enter a name for the connection.

4. Enter the connection string provided by your DBA.

5. Click OK.

To Map from a Microsoft Excel Spreadsheet

1. Perform the procedure To configure the connection to an external data source.

2. Click the Build Connection String button.
   The DB Connection window is displayed.

   

1. For Connection Type, select Excel 2003 or Excel 2007.

2. Click the ellipsis to select the desired Excel file.

3. Click the Test Connection button.

4. If the test is successful, click OK.

   DSN=Excel Files;DBQ=C:\Temp\Movies.xls;UID=<username>; PWD=<password>;

   Note: An Excel spreadsheet is available in the SampleContent folder (e.g. C:\Program Files (x86)\vizrt\Viz Multichannel\SampleContent\Database).

To Map from an Microsoft Access Database

1. Perform the procedure To configure the connection to an external data source.

2. Click the Build Connection String button

   • The DB Connection window is displayed.

     

3. For Connection Type, select Access (accdb) *or *Access (mdb).

4. Click the ellipsis to select the desired Access file.

5. Enter the database’s username and password.

6. Click the Test Connection button.

7. If the test is successful, click OK.

   Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Temp\Movies.mdb;UID=<username>; PWD=<password>;

To Map from a Microsoft SQL Server Database

1. Perform the procedure To configure the connection to an external data source.

2. Click the Build Connection String button.

   • The DB Connection window is displayed.

     

3. For Connection Type, select SQL Server.

4. Enter the database’s server name, using the following format: <hostname>:<port> _or _<IP address>:<port>.

5. Enter the database’s username and password.

6. Click the Test Connection button.

7. If the test is successful, click OK.

   Driver={SQL Server};Persist Security Info=True;Mode=ReadWrite;SERVER=<hostname>:<port>;UID=<username>; PWD=<password>;

To Map from a MySql Database

1. Perform the procedure To configure the connection to an external data source.

2. Click the Build Connection String button.

   • The DB Connection window is displayed.

     

3. For Connection Type, select MySql.

4. Enter IP address or hostname of the database.

5. Enter the name of the database.

6. Enter the username and password for the database.

7. Click the Test Connection button.

8. If the test is successful, click OK.

   Driver={MySQL ODBC 5.1 Driver};SERVER=<hostname>;DATABASE=<name>;USER=<username>; PASSWORD=<password>;

To Map from an Oracle Database

1. Perform the procedure To configure the connection to an external data source.

2. Click the Build Connection String button.

   • The DB Connection window is displayed.

     

3. For Connection Type, select Oracle (native) or Oracle (odbc).

4. Enter the database’s server name, using the following format: <hostname>:<port> _or _<IP address>:<port>.

5. Enter the database’s username and password.

6. Click the Test Connection button.

7. If the test is successful, click OK.

   DRIVER={Microsoft ODBC for Oracle};SERVER=<hostname>:<port>;UID=<username>; PWD=<password>;

To Map from a Text File

1. Perform the procedure To configure the connection to an external data source.

2. Create a folder for the text file database, for example C:\Channel32DB.

3. In the folder, create two files, such as Channel32DB.txt and Schema.ini.
   The structural details for the Schema.ini file can be found at:

   • http://www.connectionstrings.com/Providers/microsoft-text-odbc-driver

   • http://msdn.microsoft.com/en-us/library/ms709353(v=VS.85).aspx

4. In Channel32DB.txt enter a database header for mapping.

   

5. In Schema.ini:

   • [v-ind.txt] : Name of txt file database

   • Format=TabDelimited : This example uses TabDelimited

   • ColNameHeader=True : If using a header (recommended), set to True.

     Note: Another option is not to use a header, in which case you set this parameter to False; the column mapping will then be F1, F2, F3 and F4.

     {{MaxScanRows=0}}{{CharacterSet=ANSI}}

6. In the Database Connections window, enter a connection string for the text file database, in the following format

   Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=C:\Channel1_DB;Extensions=asc,csv,tab,txt; If using the Microsoft Access 64-bit ODBC drivers the format would be: Driver={Microsoft Access Text Driver (*.txt, *.csv)};Dbq=C:\Channel1_DB;Extensions=asc,csv,tab,txt;

   Note: For further connection string detail, see: http://www.connectionstrings.com/textfile.

7. Click OK.

Using ODBC 64-bit drivers

When configuring and using ODBC in a 64-bit environment you need to have 64-bit ODBC drivers installed or bridge 32-bit drivers in a 64-bit system.

A solution is to install the Microsoft native 64 drivers that is part of the Microsoft Access Database Engine 2010 Redistributable driver pack, available at (external link): http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369\-60DD\-4B64\-A44B\-84B371EDE16D&displaylang=en

However, please note that all 64-bit ODBC drivers from the Microsoft Access Database Engine 2010 Redistributable have slightly changed their driver names to differentiate them from their 32-bit counterparts.

The connection string for ODBC text and csv files will be:

See www.microsoft.com for further information.