So basically i would like to link the following two tables together History Lines and the Ledger transactions with a formula. I know this is possible because i can do this on a monthly basis using excel. Now I would like to now how do i link the two tables together so that when i create a report i can see the total sales as per income statement and then next to it i have the quantity and then i have the average selling price per litre as all clients have their own unique prices. These inventory codes are linked to certain GL CODES that represent branches and their products like : So for each truck their will be an inventory code with the extension the product. Well we have created warehouses for all our trucks and products. Firstly my database is from pastel partner and as you all know its a pervasive database. Selection of software according to Download trial key pervasive 11. I'm currently using power bi desktop to write visual reports for our business.

Any suggestions or leads would be appreciated.So i need some help with reports I'm writing. Throughout the Pervasive PSQL documentation, including this book, all content pertains to all three editions unless differences are explicitly called out.

otherwise I would just get a direct connection (which is what I was trying to do all day yesterday).Īt the end of the day, all I really need is a straightforward and low-overhead way to import data from 32-bit Progressive PSQL v11 to 64-bit SQL Server 2016 Express. The Pervasive PSQL v11 family of products include three editions of the database engine: Pervasive PSQL Server, Pervasive PSQL Vx Server, and Pervasive PSQL Workgroup. The SQL Server my software is running on is 64-bit. However, the 64-bit ODBC driver is missing for some reason (from what I've read, there SHOULD be one for PSQL v11+, but it isn't there?). Both 32-bit and 64-bit editions of Pervasive PSQL are available. Pervasive PSQL runs on system platforms that include Microsoft Windows, Linux, and Mac OS X. If nothing else, I have 32-bit ODBC connections that could be accessed from some other database system to connect and export the data that way. Actian Zen (named Pervasive PSQL before version 13) is an ACID-compliant database management system (DBMS) developed by Pervasive Software. Is there really no command that can be run from a Windows Batch File to query PSQL directly to retrieve data? Any other solution you would recommend? I've been scouring the internet all day but have yet to find any definite answers aside from the usual spam of small software companies sharing their external tools which usually have outrageous price tags. From something like a batch file, for instance. But we need to be able to set up a scheduled task to export files on a regular basis. I can do manual exports from the GUI of the application running on PSQL ( Sage 50 in this case).

I am trying to find any free method possible to automate export of Pervasive PSQL tables to CSV files.

What is pervasive psql v11