Databases - Knowledge Base

Setting up a Database Connection with SAP HANA

Overview BarTender 2022 introduces SAP HANA as a native database connection. This allows you to connect directly to your SAP HANA database, local or on the cloud, instead of requiring ODBC or passthrough connections. This article will walk you through the basics of setting up your SAP HANA databa...
New Database Connectors in BarTender 2021

BarTender 2021 and later includes the following new database connections: JSON Excel Online Google Sheets QuickBooks Online   Database Connector Improvements In the Database Setup dialog, a Row column is added to the Record Browser property page. This column specifies row numbers for the dat...
Making use of Named Database Connections in BarTender

Overview If you have any BarTender documents that share the same databases, and if those databases will be configured in the same way, you should create a Named Database Connection. Applicable to  BarTender 2016 and above Information Named database connections save your connection properties and ...
Introduction to selecting records

Overview There are a number of ways to filter data from a database for the purpose of specifying which records to print at print-time. Understanding how each method of filtering works will help you decide the best method to use for your printing requirements. Determining factors may include the d...
Using a dynamic filter (Video - 5:36)

  Applies to: BarTender 2016 and higher   This video/article uses the following downloads:Sample.xlsx Overview When you need the ability to provide filter criteria at print-time, you can use the Database Connection Setup dialog to create a query prompt that appears each time the document...
Using a static filter (Video - 2:47)

  Applies to: BarTender 2016 and higher   This video/article uses the following downloads: Sample.xlsx Overview A static filter, also known as a basic filter, is configured in Database Connection Setup, and  will always filter using the same criteria for the condition.   Dynamic filters u...
Using multiple databases or tables (Video - 4:06)

  Applies to: BarTender 2016 This video/article uses the following downloads: Database1.xlsxTable B.txt Overview Joins are basic functions of databases that enable you to merge the contents of two different tables and/or databases into a single view based on a common field or fields betwe...
Sort how the database fields are displayed in a record picker

Question  Is it possible to sort how the database fields are displayed in "record picker"? Answer YES.   BarTender v2016 You can easily do it by dragging and dropping the pertinent column on the desired place: This can be done in all record selection dialog boxes, such as the "Record picker" and...
Text database connection options in BarTender 2019 and later (video)

This articles applies to BarTender 2019 and later. Introduced in BarTender 2019, you can now import a larger variety of text database types using the database setup wizard. The wizard also allows for advanced configurations including custom field and record separators, line exclusions options, an...
Connect to a DBF database file

Question  Can BarTender be used to source data from a DBF database file? Answer  BarTender can certainly connect to this type of database, but you'll need to use a General OLE DB provider and manually configure its connection. This is what you need to do: When creating the new database connectio...
Setting up a Database Connection using QuickBooks Online

This article applies to BarTender 2021 and later. BarTender 2021 and later has added a new native database connector for Quickbooks Online. To use this feature, open the Database Setup Wizard by doing the following: Choose QuickBooks Online as the database to connect. Authenticate and connect to...
Can BarTender connect to an Azure SQL database?

Question Can BarTender connect to an Azure SQL database? Answer The answer on how to achieve this would depend on whether the connection needs to be done directly from BarTender or if a third party is connected to the Azure SQL database, and therefore BarTender needs to be integrated instead with...
Can BarTender 2019 and earlier versions connect to Google Docs?

Question Can BarTender 2019 and earlier versions connect to Google Sheets? Answer BarTender 2019 and earlier versions cannot make a direct connection to Google Docs. However, you can export data from Google Docs to a supported format for BarTender. You can then connect BarTender to the support fi...
How to connect to an IBM Informix Database?

Question  How to you create a database connection to an IBM Informix database? Answer These are the minimum requirements to connect to an Informix database: BarTender 2016 or later Informix database v11.10 or later an IBM Informix driver matching the bitrate of your system and software   You ca...
Connecting BarTender to a QuickBooks database

Overview Intuit’s QuickBooks application is a very popular accounting and business management program that contains its own proprietary database.  There are two ways to connect BarTender to Quickbooks.   Connecting to QuickBooks directly via ODBC For more information about using the ODBC driver p...
How to fallback and force BarTender to use the Microsoft Access Database engine driver (OLEDB / JET) in BarTender 2019 and later

This applies to BarTender 2019 and later Starting with BarTender 2019, BarTender will natively read Excel and Access files as long as they are in the current format that Microsoft Office uses.  Please see What Access and Excel file extensions are compatible with BarTender 2019 and later? for more...
What Access and Excel file extensions are compatible with BarTender 2019 and later?

Question Now that we are use our own drivers in BarTender 2019 and later, what Excel and Access file extensions do we support? Answer This articles applies to BarTender 2019 and later. Our drivers are compatible with the modern / current file extension in Excel and Access, however when a customer...
How to view database records in label design

Question  How can I see my records on the label design Answer  You can view records and navigate through them in label design by turning on the live database connection. Click on the Cylinder icon on the bottom left of the design window above the Template tab. This should enable the view of recor...
Can the Database Connection be changed on multiple documents at once?

Question Is there a way to change the database connection in multiple documents at the same time. Answer No, each database connection is saved to the document so each document has to have its own database connection modified. One way to prevent this problem in the future is to use Named Database ...
How to manually remove named database connections

Symptom  User has created named database connections that are no longer needed and would like to remove them from BarTender Environment  BarTender 2016+ Fix/Answer  Currently there is no way to remove the named database connection from within BarTender and you will have to remove the connections ...