Goldstar Logo
Your Source for PSQL Database Products, Services and Training Since 1997 EMail: Sales@goldstarsoftware.com 
Phone: 1-708-647-7665 
Web Site Login 
Free PSQL Support
Quick Links
Database Engines
+ Actian Zen v13
+ Actian PSQL v13
+ Actian PSQL v12
+ Actian PSQL v11
+ Pervasive PSQL v10
+ Pervasive PSQL v9
+ Pervasive.SQL V8
+ Pervasive.SQL 2000i
+ Pervasive.SQL 7
+ Btrieve v12
+ Btrieve 6.15

+ Data Protection Products

+ Goldstar Software Services

+ Goldstar Software Tools

+ Other Solutions

AMS Users: Click Me Fix My PSQL License Repair PSQL Files Get Support Now Join Our Mailing List

Navigation Background

White Papers About the Actian Analytics Platform and Vector Database

By: Bill Bach

This page contains white papers created by Goldstar Software Inc. which cover migrating data from PSQL to Actian Vector via the Actian Analytics Platform solution, provided with PSQL v12.

Click on the PDF icon to download the complete document in Acrobat format. Can't open the PDF files? Please visit www.adobe.com for a free download of Adobe Acrobat Reader.

PDFInstalling the Vector ODBC Driver for 32-bit Applications
If you will be using the Vector database from a 32-bit ODBC application, you will need the 32-bit ODBC drivers installed. Here are the steps to downloading and installing these drivers. (Written 09/17/2015)

PDFConfiguring the Vector ODBC Driver
With the ODBC drivers installed, you still need to configure them to connect to your Vector database. This paper explains exactly how to do this. (Written 09/17/2015).

PDFConfiguring AAP Database Sources
You will need to configure the Actian Dataflow (KNIME) environment to see your PSQL databases. (I *really* wish they would make this work by default.) This paper explains how to configure KNIME for PSQL and how to create new databases that can be used within the Actian Dataflow environment. (Updated 09/23/2015)

PDFCreating a Simple AAP Data Migration
One of the primary reasons for using the AAP/Vector environment is the high-speed reporting engine. In order to use this engine, though, you have to first migrate your data over to the Vector instance you have created. This paper shows you how to create a very simple Dataflow project to migrate all data from two simple tables in your PSQL database directly to a Vector instance. This is the simplest case and does not include any data filtering, manipulation or translation. (Updated 09/23/2015)

PDFComparing Queries: Vector versus PSQL
When you have your data in the Vector database, you will want to directly compare the performance of this system with your other systems. This paper explains how to compare your database engines using our SQLExec utility. (Updated 09/24/2015)

For more papers, see this Google+ link.

  Copyright © 1997-2017, Goldstar Software Inc., All rights reserved. PRODUCTS | SERVICES | TRAINING | SUPPORT | DOWNLOADS | ABOUT US  
Goldstar Software Inc. | 3007 Carmel Dr | Flossmoor IL 60422 Legal Statements | EULAs | Uninstall | Privacy Statements | Contact Us