Or, will he have to create it? If so, how does he do this. Click Here to join Tek-Tips and talk with other members! Are you importing the report onto the Auto Connect system? This is where the 32 bit odbc manager is:

Uploader: Tojazragore
Date Added: 12 June 2016
File Size: 42.79 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 24044
Price: Free* [*Free Regsitration Required]

Live queries in-database No Yes, when feasible. Select the final Spotfire data table.

I can’t find any information about one. Students Click Here Join Us!

ODBC – The Sage Intelligence Community

I am not importing at all. ODBC Documentation is available here. Does the full version of Pervasive have to installed on the workstation? By doing all data transformations and visual analytics on a copy of the bsinessworks table produced by the ODBC data source, you are able to use Spotfire’s replace data table feature to switch out the original data source while keeping data transformations intact.

I understand that the underlying Pervasive. Don’t forget to install the driver on the Web Player nodes you plan to share your analysis on as well. If so, Have you check tested your connection to your Peachtree Database businsesworks Server?


This will launch the Specify Tables and Columns dialouge.

The data source can be seen in Spotfire’s SourceView: Is it something I need to download? Jay Wendland at jay. The new 2 table is visible in the SourceView. Or, will he have to create it? Please note that parallel queries will queue. It was not possible to connect to the database.

How do I connect to the program using ODBC/OLEDB?

As you begin to select tables and column the corresponding SQL statement will be generated. Spotfire currently doesn’t include native support for Data but you can use the generic ODBC support described above to retreive data. Sign Up or Sign In.

Red Flag This Post Please let us know here why this post is inappropriate. Yes, on installed clients and web player servers. Register now while it’s still free!

Yes, for web player users Spotfire Business Author and Consumer users. I’ve got a client with a Busineseworks Gold v6 setup, and an application a web-catalogue he wants to talk to it. YOu can do the same test on the container. Please contact your Sage business partner, network administrator, or accountant businessworkks assistance.


Is there an “evaluation copy” of BWG v6 available so we can try out setting up the database connection without harassing the customer? I can’t just tinker with his machine because he’s 5,km away, and don’t have a BWG v6 install here to dry-run everything against.

How to create ODBC DSN drivers for Sage BusinessWorks

If you encounter any issues with the ODBC driver support requests are submitted here. The Sage Intelligence Blog. I don’t know how to get to the Pervasive control center. I am receiving the same error and I do have the Connector Module. Click Here to join Tek-Tips busihessworks talk with other members!

Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.