You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
Need immediate help? Phone support is available between Monday and Friday from 9am to 9pm EST at 888-297-6172
announcement close button
Home > How to Use Transaction Pro > How to Import Using Transaction Pro Importer - NEW > Desktop Importer - NEW > Use a SQL Data Source with Rightworks Transaction Pro Importer
Use a SQL Data Source with Rightworks Transaction Pro Importer
print icon
Oct 17, 2023
views icon 250

QUESTION

 

Can a SQL data source be used with Rightworks Transaction Pro Importer?

 

RESOLUTION

 

To connect to a SQL data source, follow the steps below:

 

  1. In Importer, choose DSN for the file source and then click CONNECT

  2. Select the MACHINE DATA SOURCE tab

  3. Click NEW

  4. An error message will appear that says it cannot create a system DSN due to insufficient permissions -click OK

  5. Go through the Wizard, selecting the SQL Driver

  6. Click FINISH to setup the driver

  7. The SQL tables should now be visible in Importer

Feedback
0 out of 1 found this helpful

Tags

close button
scroll to top icon