Find out how to Create an ODBC DSN to Access Pastel Accounting Company Information (Pervasive Workgroup)
It is very easy to create and Open Database Connectivity (ODBC) Data Source (DSN) to access your Pastel Accounting firm knowledge and this doc will show you how.
• Watch out to use read-solely mode because you may change data, (helpful for data repair)
• This procedure on this doc is just for use with Pervasive Workgroup installations, (the same process on Pervasive Server has more steps)
1. Open Pervasive Management Centre
a.Accessing Pervasive Management Centre from the menu
i.From the Start menu, Choose Applications -> Pervasive (If it isn't there acquired to b.)
ii.From the Pervasive Menu, Select Pervasive.SQL -> Pervasive.SQL Management Centre.
b.Different: Access Pervasive Management Centre from the Run command
i.From the Begin menu, Choose Run.
ii.Type PCC.exe into the textual content field and click OK.
iii.The Pervasive Control Centre Opens
2. From the Engines node: Develop the computer node to see the Databases node.
3. Develop the Databases Node
four. Proper Click the Databases folder to entry Context Menu, Choose New -> Database
5. The New Database Screen opens
6. Enter PASTELDEMO into the Database title Field and press Tab
7. When within the location subject, click the ellipsis button to open the Browse for Folder Window
From the Browse for Folder display screen, discover and choose the _Demo subfolder of your Pastel installation. (In your live data use the pastel firm information directory, but comply with alongside until you are clear on the process)
8. On the remainder of the New Database Display full the fields as beneath.
a.Deselect Create dictionary information
b.Deselect Relational integrity enforced
c.Select Read Solely from the Open mode dropdown
9. Click on Finish to save lots of the new database. The brand new database will seem as an expandable node beneath the Databases folder in PCC (Pervasive Management Centre).
10. Increase PASTELDEMO -> Broaden Tables
you'll be able to see tables that Pastel makes use of to retailer its knowledge (see checklist of tables and fields in other posts)
eleven. Double Click on CustomerMaster table to view the info stored within the table.
While you Double Click on the desk it creates the SQL query "Select * from CustomerMaster", which means "Choose all columns from CustomerMaster". You can see columns of data within the grid part.
To raised perceive what you're seeing, examine the grid data to the information within the Clients Explorer grid in the Pastel _Demo Firm. Discover the ‘Ackerman Mr R' in both programs.
Your Supply Data in your Pastel Accounting Xpress/ Accomplice is now accessible.
Knowledgable microsoft Office users must be off to a flying start now when it comes to creating refreshable spreadsheets and maile merge word paperwork. A couple of ideas for spreadheets would may very well be costing schedules for mission type corporations, commision spreadsheets for salepeople, selecting slips and delivery schedules,
Mail merge documents are fantastic for sales orietated type duties, especially when choice components corresponding to gross sales volume, territory, gross sales code and many others. may be specified for sniper accuracy in supply concentrating on
I hope this article has stimulated your curiosity in leveraging your current Pastel accounting investment
In our next entry we are going to show you the way to use this ODBC DSN that we now have just created to access transaction data immediately from Microsoft Excel.