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 |
|---|---|---|
| fin | ndbcn@xxx | CFront for Native NAV Database (xxx is version ID) |
| fin | ndbcs@xxx | CFront for SQL NAV Database (xxx is version ID) |
| 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) |
| ms | bc | Direct SQL access to BC SQL Database |
| lsws | none | LS Central Web Service v1 |
| 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 |
| ax | none | Microsoft Dynamic AX 2009 Database |
| ax | 2012 | Microsoft Dynamic AX 2012 Database |
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 and later Additional Object replication commands for finsql process:
| navservername | navsrv |
| navserverinstance | navinst |
| navservermanagementport | navport |
| tenant | navten |
| synchronizeschemachanges | navsync |
AX special connection string commands:
| provider | |
| domain | |
| language | |
| cfg | |
| object_server | |
| port |
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 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
-
Microsoft Dynamics NAV Native Server – Standard Connection
company=mycompany;server=myserver;user=dd;passwd=ddpwd;|fin|ndbcn@602
-
Microsoft Dynamics NAV SQL Server – Standard Connection
company=mycompany;server=myserver;user=dd;passwd=ddpwd;|fin|ndbcs@602
-
Microsoft Dynamics NAV SQL Server – Trusted Connection
company=mycompany;server=myserver;|fin|ndbcs@602
-
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 Business Central – LS Web Service v1
company=mycompany;server=http://myserver:7047/BC130/WS/mycompany/Codeunit/RetailWebServices;user=nav;passwd=navpwd;|lsws|non
-
Microsoft Dynamics AX 2009 – Standard Connection
user=dd;passwd=ddpwd;domain=retail;company=lsr;object_server=LSRetail@server:2713;cfg=;|ax|none
-
Microsoft Dynamics AX 2009 – Trusted Connection
user=dd;company=lsr;object_server=LSRetail@server:2713;cfg=;|ax|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