If so, what– just a valid BusinessWorks login or a special magic value? You will now see the selected tables listed in the database window. Connection settings are configured and stored in Spotfire Data Source objects. We will use Microsoft Excel for this example: Select a table from the list, click Next , and click Finish. Enter the User Name and Password on the login window.

Uploader: Moogurisar
Date Added: 23 January 2010
File Size: 18.84 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 7309
Price: Free* [*Free Regsitration Required]

Talking to BWG v6 via ODBC – BusinessWorks (Sage) solutions – Tek-Tips

Can you open up report manager and check system variables. If so, what– just a valid BusinessWorks login or buisnessworks special magic value?

Is it something I need to download? By doing all data transformations and visual analytics on a copy of the data 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 busibessworks data transformations intact. See Related Resources Section for businessworls locating your company folder. Please contact your Sage business partner, network administrator, or accountant for assistance.

I’ve got a client with a BusinessWorks Gold v6 setup, and an application a web-catalogue he wants to talk to it. In Spotfire, you only need to select the DSN enter your database credentials. I get the error trying to run any existing report.


We will use Microsoft Excel for this example: The new 2 table is visible in the SourceView. Connect to Data, define an ODBC data source, define your original Spotfire data table and load the corresponding rows. Use the following steps:. Whenever you need to edit the data businesseorks go to the Source View and click the data source’s two reload arrows.

Click OK on the Import Data odnc. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden. Even if it forces you to use sample data, that’s fine, as long as it provides a way to test the connection to the database.

Select the final Spotfire data table.

How to create ODBC DSN drivers for Sage BusinessWorks

Make sure you can view the data from that table, this will confirm if your Pervasive driver is functioning properly.

Select one or more tables from the list hold down the control key to select more than one businesssworks and click OK. In the Open Database dialog, click OK again.

Specify proxy information and if you will use stored procedures. Enter your database username and password and click OK. Skip to main content.

After your serial number is confirmed, you will receive the activation code within 1 business businesswokrs.


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

Enter a password and confirm it. This is where the 32 bit odbc manager is: This is not yet possible without the workaround below but please vote for the idea here. We will use Microsoft Excel for this example:. Select a table from the list, click Nextand click Finish. See below The next thing you could do is check test the actual report, right select on the report and select check test.

Please review this document for additional information on the scope of Sage Customer Support Services. Yes, for web player users Spotfire Business Author and Consumer users. I can’t find any information about one. Keith, I don’t know how to get to the Pervasive control center.

Sage Customer Support does not provide assistance for issues related to third party products or enhancements, hardware, report customizations, state or bjsinessworks tax-related questions, or specific accounting questions.