ConnectionString Attribute
Each
Import
element has a ConnectionString
attribute that defines an OLE-DB connection from the adapter to the external data
source. However, the format of the ConnectionString
attribute
depends on the Type
attribute of the Import
element, which declares the type of data source to which the adapter connects for
this particular import.Note: The Business Importer is a 32-bit application,
and 32-bit OLE-DB connection strings must be used on 64-bit operating
systems.
Tip: For guidelines about building and validating a connection string, see
Validating Connection Strings.
The following table shows, for each Type
of data source that the
import may use, the different format and attribute values for the
ConnectionString
.
Type attribute of Import |
ConnectionString attribute of
Import |
---|---|
ADSI |
ADSI is used for directory data import, such as from Active Directory or
eDirectory. Acceptable formats for
ConnectionString
when using this data source are:
|
CSV |
This import
In all cases, to specify the properties of each column in the
imported file, use a Type may be used both for files with
delimited values (as in a true comma-separate value file), or for text
files with fixed-length values.
schema.ini file (see Editing a Schema.ini File). |
Excel |
The format depends on which version of spreadsheet files you are
importing.
|
ODBC |
ODBC is a generic driver than can be used in conjunction with the
"Microsoft OLE-DB Driver for ODBC Drivers". The connection string varies
according to the driver used. This example is for a connection to an Excel
file using a test DSN:
|
OleDB |
OleDB is a generic driver that can be used with a variety of
databases, such as Microsoft Access, Ingres, Paradox, and others. The
prerequisite is that the corresponding OLE-DB driver has been installed
and configured on the computer where the import is run. Example for
Microsoft Access:
|
Oracle |
Oracle connections require the installation of an Oracle client provided
by Oracle Corporation. The Oracle client should install the OLE-DB
driver for Oracle. The format
is:
Tip: Do not include the provider in this connection
string.
|
SqlServer |
The format depends on the authentication model.
Tip: Do not include the provider in this connection
string.
|
WebService |
Web services can be called using a SOAP request. The connection string
must contain the URL and, if authentication is needed, the credentials:
Or, with
credentials:
|
XML |
Allows for import of XML files. The connection string must contain the
path and name of the XML file:
Enclosing quotation marks are mandatory when the values include white
space, and otherwise optional.
Example:
|
FlexNet Manager Suite (On-Premises)
2023 R2