How can we help?

Setting Report Data Connections for Sage 50 and Peachtree

You are here:
Go Back

Each report may have Data Connection(s) to a Sage 50 or Peachtree Company.  When you install a new report you must set the data connection to the Sage 50 Company you wish to work with.

Before you can set this connection you need to make sure your Sage 50 / Peachtree has allowed access to the database.  Instructions here

You will need to add and create a password for each Sage 50 / Peachtree Company.  The password may be the same for each company.

There are 3 ways you can set the data connection for a report.

 

DBQ Name

DBQ Name is an alias to the database location.   You can create and use the existing DBQ name as your connection.  DSStudio provides the ability to create, delete, and view DBQ Name entries.  DBQ Entries only contain the alias to the database location.  You will need to provide a User ID and Password to access the database.  More Information

Custom Connections

Custom Connections don’t use the DBQ Name, you provide the connections details including the data location, username, and password.  More Information

Stored Connection

Stored Connections allow you to save your connection to be reused easily.  Stored connections will save the complete database connection including the User ID and Password.  It is provided for ease of use, not for security.  Your User ID and Password will to visible on the screen.

It does not matter which method you use, they all make the same connection.  Using DBQ Name is a bit easier as DSStudio will be prompted you for the connection requirements and Custom Connections will have to be manually typed but may provide more options if needed.

Both DBQ Name and Custom Connections will protect your passwords.   After you have established the connection DSStudio Viewer will hide passwords.  If you are using Stored Connections they will retain the password in clear sight.  Depending upon your office security policies you will have to choose which connection will protect your password.  More Information

NOTE: The data access password you created in Sage 50 Security Settings does not allow the user to log into the  Sage 50 program.  It only allows READ ONLY access to your data to the outside applications like DSStudio.  Anyone using this password will not be able to change any data within your Sage 50 or Peachtree Accounting database.

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Previous Sage 50 and Peachtree Database Access Setup
Next DBQ Names – Pervasive / Actian
Table of Contents

Sage 50 and Peachtree Accounting Data Services

Data Recovery

Sage 50 US and Peachtree Accounting Data File Repair Service.

 Fiscal Period Change

Change the fiscal period time for a Sage 50 or Peachtree Accounting Company.

Data Transition

Many data-related services, which include: Sage 50 Product Downgrade, Quote Removal Service, Failed Fiscal Year Close Fix, and bulk change inventory item costing.

Purge Service

Data Purging Service for Sage 50 and Peachtree Accounting.  Reduce file size increase program speed.

Sage 50 Shell Company

Rebuild your Sage 50 / Peachtree Company in half the time.

Sage 50 Quote Stripping

Unable to import transactions into a new company.  The quote ” maybe getting in your way.