Dependencies
The Lyftrondata Provider for SAP Business One DI connects through the DI API. In order to use it, there are some dependencies from SAP Business One that must be installed on the connecting machine in order to communicate.
Please see Dependencies for details.
Connection Details
To connect to data, specify the following connection properties:
- DBServerType - The type of server being connected to.
- Server - The SAP Business One server to connect to.
- CompanyDB - The company to connect to.
- User - The username used when connecting to the LicenseServer.
- Password - The password used when connecting to the LicenseServer.
In addition, the following optional connection properties may be specified:
- LicenseServer - If this is different from the Server.
- UseTrusted - If set to true, it indicates you are establishing a connection to SQL Server via windows credentials. Otherwise if set to false, you can use DBUserName and DBPassword to specify the database credentials. It is not necessary to specify UseTrusted, DBUserName or DBPassword when connecting to SAP Business One 9.0 and above with an established UI connection to the LicenseServer.
Advanced Settings
The Lyftrondata Provider for SAP Business One DI enables the granular control useful in more complex deployments and network topologies; you can use the following properties to connect through a firewall or troubleshoot connections.
Optional Connection Properties
Additional connection properties may be specified depending on your need. These include:
- LicenseServer - If this is different from the Server.
- SLDServer - The System Landscape Directory. Typically this will be automatically resolved.
- UseTrusted - If set to true, it indicates you are establishing a connection to SQL Server via windows credentials. Otherwise if set to false, you can use DBUserName and DBPassword to specify the database credentials. It is not necessary to specify UseTrusted, DBUserName or DBPassword when connecting to SAP Business One 9.0 and above with an established UI connection to the LicenseServer.
- DBUserName - Set only if UseTrusted is set to false and connecting either SAP Business One 8.82 and below or without an established UI connection to the LicenseServer.
- DBPassword - Set only if UseTrusted is set to false and connecting either SAP Business One 8.82 and below or without an established UI connection to the LicenseServer.
- Language - The multi-language support option to use.
- SecurityCode - An additional security code to go with the User and Password in case additional security features are enabled.
QueryPassthrough
The QueryPassthrough connection property indicates that your queries will be passed as-is to the underlying database for SAP Business One. It is enabled by default. If set to false, queries being passed to SAP Business One will be altered to comform to SQL Server standards.
Troubleshooting the Connection
To show provider activity from query execution to network traffic, use Logfile and Verbosity. The examples of common connection errors below show how to use these properties to get more context. Contact the support team for help tracing the source of an error or circumventing a performance issue.
- Authentication errors: Typically, recording a Logfile at Verbosity 4 is necessary to get full details on an authentication error.
- Queries time out: A server that takes too long to respond will exceed the provider's client-side timeout. Often, setting the Timeout property to a higher value will avoid a connection error. Another option is to disable the timeout by setting the property to 0. Setting Verbosity to 2 will show where the time is being spent.