You can follow the steps to create a linked server for QuickBooks in SQL Server Management Studio by using Object Explorer:
- Start your Management Studio and choose your SQL Server instance.
- In the Object Explorer pane, expand the Server Objects, right-click on Linked Servers and then click on New Linked Server.
- Configure your linked server in the dialog box:
- Give a name for your server in the Linked server field.
- Under Server type, select Other data source .
- Choose Microsoft OLE DB Provider for ODBC Drivers in the Provider drop-down list.
- In the Data source field, enter the name of your DSN, e.g. Devart ODBC Driver for QuickBooks . Alternatively, you can input the ODBC Driver connection string in the Provider field.
- The linked server will appear under the Linked Servers in the Object Explorer Pane. You can now issue distributed queries and access QuickBooks databases through SQL Server.
Retrieving Data From QuickBooks
Disable the Allow inprocess option of MSDASQL OLE DB Provider for ODBC Drivers. For this, find the MSDASQL provider in the list of Linked Servers and double-click on it
- In the appeared Provider Options window, clear the Allow inprocess checkbox:
- Create a new Linked Server
- Make sure to select Microsoft OLE DB Provider for ODBC Drivers and specify the following parameters:
- The QuickBooks tables are already available to be fetched. To query the linked server, click New Query in the toolbar:
- Enter your SQL query in the editor window and click Execute to run the query:
- As a result, you can see the contents of the selected table retrieved directly from the QuickBooks account you are connected to.
This may help you,
Rachel Gomez