# Connector Manager - Data Source Types

The following is a list of supported Data Source Types, and the specific information that may be required to build a Connector.

### Microsoft Access Databases

### Microsoft Excel Spreadsheets

Inaport needs to know the version of Excel that has been used to create the spreadsheet.

### Microsoft SQL Server Database

Inaport will need the name of the server that SQL Server is installed. You will need the SQL Clients installed as a minimum to connect to SQL Server.

### Text files

To create a text file connector you need to enter the following:

- Whether the first row has field names.
- The text delimiter to use
- The field delimiter to use
- The record delimiter to use
- The encoding of the character set

The optional parameters you can set are whether you want to move the file once it has been processed and whether you want to rename the file too. Note that you can use expressions here, but there is no access to the expression editor. An example of using an expression is to use the date in the extension, i.e. putting ".done" + date("yyyyMMdd") in the change extension to edit box would change the extension to something like .done_20040129 and this is useful when you have regular imports to be done and you want to preserve the ones that have been processed.

### Microsoft CRM V4 and 2011

Inaport will need to know the URL of the CRM instance.

### dBase Database Files

Inaport needs to know the version of the dBase files, so that it can use the correct index files.

###

### ACT! by Sage, Versions 8 and up

Inaport needs the location of the .dbf file (Version 6) or the location of the .pad Database Definition file (Versions 7 and 8).

###

### Sage CRM Versions 5.6, 5.7, 5.8 and 6.0 on Microsoft SQL Server

Inaport needs to know the SQL Server name. You will need the SQL Clients to be installed to connect to the SQL Server database. You need to specify the user that you want the imported records to belong to by default.

### Sage CRMcom 5.8f, 6.0, 7.x on a hosted web site

Inaport needs the correct URL for the hosted CRM instance.

### Sage CRM Infor CRM 5.2, 6.0, 6.1, 6.2, 7.0, 7.1 on Microsoft SQL Server 2000

Inaport will need to know the instancename of the server that SQL Server is installed along with the username and password of the owner of the database. It will also need the BDE Alias to connect to the SalesLogix database, along with the username and password to log into SalesLogix. You will need the SQL Clients installed as a minimum to connect to SQL Server.

###

### Sage CRM SalesLogix 5.2, 6.0, 6.1, 6.2, 7x. on Oracle 9i

Inaport will need to know the Oracle named instance, with the username and password of the owner of the database. It will also need the BDE Alias to connect to the SalesLogix database, along with the username and password to log into SalesLogix. You also have to option to choose a different OLEDB Provider for the Connector, the default provider is 'OraOLEDB.Oracle', you can change this to use the Microsoft OLE DB Provider, to do this you need to enter the string 'MSDAORA' in the box provided.

### GoldMine 5.x, 6.x on dBase

Inaport will need to know the locations of the dBase files for both the system tables (CAL etc) and the contact set tables (CONTACT1 etc).

### GoldMine 5.x, 6.x, 7.x, 8.x, 9.x on SQL

Inaport will need to know both the BDE alias to log into the databases, and connection information for the SQL Server hosting the GoldMine tables.

###

###