Import > Import via connection file

Import via connection files extremely extends importing capabilities of CutLogic 1D. Connection file is a file containing information how to connect to existing data source via ODBC or OLE DB driver installed on computer where CutLogic 1D runs. Connection file is simple text file with one line including connection definition.

Example connection file cf1.conn for Microsoft SQL Server:

Provider=SQLOLEDB; Server=myServerAddress; Database=myDataBase; Uid=myUsername; Pwd=myPassword;

You can also define table name, for example:

Provider=SQLOLEDB; Server=myServerAddress; Database=myDataBase; Uid=myUsername; Pwd=myPassword; TableName=Orders;

Or you can define SQL statement, for example:

Provider=SQLOLEDB; Server=myServerAddress; Database=myDataBase; Uid=myUsername; Pwd=myPassword; SQL=select * from Orders where MaterialNo = 321 order by Length;

One more example, ODBC connection to Firebird SQL database using complex SQL statement:

DRIVER=Firebird/InterBase(r) driver; UID=SYSDBA; PWD=masterkey; DBNAME=myServer:C:\data\ERP.fdb;

sql=

select Orders.*, Customers.CompanyName

from Orders

left join Customers on Customers.ID = Orders.CustomerID

where Orders.MaterialNo = 411

order by Orders.Date

For more information how to define connection string for your specific data source, see www.connectionstrings.com or contact us.