Connecting to the database
The ODBC Data Provider enables EasyCatalog to directly connect to your database
Last updated
Was this helpful?
The ODBC Data Provider enables EasyCatalog to directly connect to your database
Last updated
Was this helpful?
EasyCatalog ODBC Data Provider needs a suitable installed. Creating and working with an ODBC Data Source works in the same way as working from a flat-file, although requires slightly more configuration.
Before a data source can be configured in EasyCatalog, you must first use either:
Macintosh
Windows
The ODBC Data Sources control panel. On Windows 11, use the search tool and type ODBC to open the ODBC Data Sources Administrator tool.
Using either of these, a new Data Source must be configured. This Data Source contains information on how to connect to your database, the type of database being used, etc.
This configuration should be performed prior to configuring your new data source in EasyCatalog.
Setting up EasyCatalog to use an ODBC Data Source is a straight forward process as long as the data source has been configured correctly in the ODBC Manager/ODBC Data Sources application.
To create a new ODBC Data Source in EasyCatalog navigate to New > EasyCatalog Panel > New ODBC Data Source. This will open the dialog shown in the screenshot below.
The name of the data source –this will be used to refer to the data source by EasyCatalog. The data source needs a unique name, which will be used to identify it later by EasyCatalog. The data source will be added to your workspace folder within EasyCatalog and subsequently available from the File→New→EasyCatalog panel menu.
A list of the ODBC Data Sources configured in the ODBC Manager application (Macintosh) or ODBC Datasources Administrator Tool (Windows) is shown here. Select the data source you are connecting to to pre-fill the Connection String.
In order for EasyCatalog to connect, a username and password must be specified. This is done by adding UID=USER;PWD=PASS; to the connection string. Alter USER/PASS with the details appropriate to the host.
The Connection String is a series of parameters that contain information on how to connect to your database. The format of the connection string is based on the ODBC Connection String standard, and consists of a series of keyword/value pairs separated by semicolons. The equal sign (=) connects each keyword and its value.
In it’s simplest form a connection string needs only to specify a data source name, which is configured separately in the ODBC Control panel (on Windows) or the ODBC Manager application (on Macintosh).
A list of the typical connection string keywords and values is shown below. Note that whether they are supported depends on the ODBC driver you are using. The options specified by the connection string override any settings made in the Data Source configuration in the ODBC Control panel (Windows) or ODBC Manager (Macintosh).
DSN
Data source name
HOST
Server host name
SVT
Database server type
DATABASE
The name of the database to connect to
OPTIONS
Database-specific options
UID
User Name
PWD
Password
READONLY
N/Y/I
FBS
Fetch-buffer size
STMT
Specify a statement that will be executed after the connection to the database.
Example:
Click this button to see a full list of tables available in your database. This dialog can also be used to build the SQL statement.
The statement needs to be modified to select from the correct table (if unsure of which table to use, the available tables are shown by selecting the Tables… button), in this case the table is called Productos. The encoding should be set to the same encoding as the ODBC driver. Press Execute to execute the query, if the query has been successful it will show fields and some data in the Sample area.
The statement is used to specify the exact data to retrieve from the database, and takes the form of a standard SQL-compliant request.
The exact syntax and use of SQL is beyond the scope of this guide, and there are many SQL tutorials available. This guide assumes that you have a working knowledge of your database and are able to retrieve your data using SQL.
Change this pop-up if you are using a Unicode-compliant database. Depending on the ODBC driver being used, select either Unicode or Utf-8.
Macintosh only: For non-Unicode databases, select windows latin 1 if the text in the database was originated from a Windows machine.
Click the Execute button to test the Connection String and SQL statement settings. The results returned by the query will be shown in the sample window.
The results of the database query will be shown here. Use this area to ensure the results are as expected, and to configure Field Options.
Select one of the columns returned by the query in the Sample pane and click the Options button to configure its Field Options.
The application, which is usually located in the applications>Utilities folder.
allows you to specify exactly what to retrieve from the database. By using SQL, your database can be interrogated in an almost infinite number of ways.
Once successfully configured and tested, at least one field must be configured as the — a field which can be used to uniquely identify each record from the database.
