This shows several examples of connection strings that you can use in your setup. In most cases it is just a matter of copying the string shown and changing the database name, user, and password.
The DD connection string consists of three sections: database-specific connection string, database type, and database-specific string. These three parts are separated by the “|” symbol. Each section is configured with parameters that can be different for each database type.
Syntax: <database connection string>|<database type id>|<database specific string>
Supported database types are:
| Types | Specific Str | Description |
|---|---|---|
| mssql | none | Microsoft SQL Server Database |
| mssql | schema=xxx | Microsoft SQL Server Database with different schema name for table than default dbo |
| ms | navxx | Direct SQL access to NAV SQL Database not using CFront (xx is the NAV version number) and only to be used for NAV version 11 and older |
| ms | bc | Direct SQL access to BC/365 SQL Database |
| lsws | none | LS Central SaaS Web Service v1 |
| lsws | s2s | LS Central SaaS Web Service v1 using oAuth (S2S) for authentication. This is used to access LS Central in Microsoft SaaS enviroment. |
| file | none | Export/Import Data to/from file Tab delimited with txt extension |
| file | xxx@d | Export/Import Data to/from file (xxx is the file extension and d is tab delimiter character) |
| xml | none | Export/Import Data to/from XML file (values as Elements) |
| xml | attr | Export/Import Data to/from XML file (values as Attributes) |
| oledb | none | OleDB access to Database |
| odbc | none | ODBC access to Database |
| mysql | none | MySQL Database Server |
| ext | External Data Processing using DDDatabaseExt process. |
DD knows how to process connection strings designed for one type of database and use them to connect to a different type of database. For example, a NAV native connection string can be used to connect to an SQL database, as DD knows different commands for each item in the connection string.
These are the commands that DD understands for connection string item:
| Database Server: | server, data source, address, network address |
| Database Name: | initial catalog, database, dbname, datapath |
| Database User Name: | user id, user, uid |
| Database User Password: | passwd, password, pwd |
| Database Security Mode: | integrated security, trusted_connection |
| Network Library | nt, net, network library |
| LS Location id: | locationid, id |
| LS Central Company Name | company |
NAV 2013-2018 Additional Object replication commands for finsql process:
| navservername | navsrv |
| navserverinstance | navinst |
| navservermanagementport | navport |
| tenant | navten |
| synchronizeschemachanges | navsync |
For information on how to put together a connection string for your database, see http://www.connectionstrings.com/. This site has samples of the most common database servers and data providers out there.
If a connection string does have some special features that do not fit the current rules that DD expects, then put “cust” in <database specific string> value and DD will use the connection string as is without trying to process it.
The following are examples of connection strings:
-
Microsoft Dynamics 365 BC – LS Central Web Service v1
company=mycompany;server=http://myserver:7047/BC130/WS/mycompany/Codeunit/RetailWebServices;user=nav;passwd=navpwd;|lsws|none
-
Microsoft Dynamics 365 BC – SaaS
server=http://myserver.dynamics.com/Production/WS/mycompany/Codeunit/RetailWebServices;user=ClientId;passwd=ClientSecret;Database=TenantId;|lsws|s2s
-
Microsoft Dynamics NAV 201x – Standard Connection
company=mycompany;Initial Catalog=mydata;Data Source=myserver;User ID=dd;Password=ddpwd;|ms|nav80
-
Microsoft Dynamics NAV 201x – Trusted Connection
company=mycompany;Initial Catalog=mydata;Data Source=myserver;Integrated Security=SSPI;|ms|nav80
-
Microsoft Dynamics NAV 201x – Server Tier/Instance for FOB import
company=mycompany;Initial Catalog=mydata;Data Source=myserver;Integrated Security=SSPI;navsrv=myserver;navten=mytenant;navport=7045;navinst=myinstance;|ms|nav80
-
Microsoft Dynamics 365 BC – Standard Connection
company=mycompany;Initial Catalog=mydata;Data Source=myserver;User ID=dd;Password=ddpwd;|ms|bc
-
Microsoft SQL Server – Standard Connection
Initial Catalog=mydata;Data Source=myserver;User ID=dd;Password=ddpwd;|mssql|none
-
Microsoft SQL Server – Trusted Connection
Initial Catalog=mydata;Data Source=myserver;Integrated Security=SSPI;|mssql|none
-
Microsoft SQL Server – Trusted Connection with user login
Initial Catalog=mydata;Data Source=myserver;Integrated Security=SSPI;User=domain\dd; Password=ddpwd;|mssql|none
-
OleDB – Standard Connection
Provider=SQLOLEDB;Initial Catalog=mydata;Data Source=myserver;User Id=dd;Password=ddpwd;|oledb|none
-
ODBC – Standard Connection
Provider=SQLOLEDB;Initial Catalog=mydata;Data Source=myserver;User Id=dd;Password=ddpwd;|odbc|none
-
Semicomma separated File Import / Export
Database=mydatafolderpath;|file|csv@;
-
XML File Import / Export
Database=myxmlfolderpath;|xml|none