Oct 17, 2023
461
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:
-
In Importer, choose DSN for the file source and then click CONNECT
-
Select the MACHINE DATA SOURCE tab
-
Click NEW
-
An error message will appear that says it cannot create a system DSN due to insufficient permissions -click OK
-
Go through the Wizard, selecting the SQL Driver
-
Click FINISH to setup the driver
-
The SQL tables should now be visible in Importer