SSIS Components for GraphQL

Build 21.0.7940

Establishing a Connection

Connecting with the GraphQL Connection Manager

Adding a new GraphQL connection to the SSIS package is straightforward. Right-click within the Connection Manager window and select New Connection from the menu. Then, choose the GraphQL Connection Manager from the Add SSIS Connection Manager window.

Alternatively, you can create a new connection directly using the GraphQL Source or the GraphQL Destination. You can set the connection properties in the GraphQL Connection Manager window.

Before Connecting

Before a connection to data can be made, custom schema files must first be configured to model the data being accessed.

See the Modeling GraphQL Data section for a breakdown of the custom schema creation process.

Connecting to GraphQL

Set the following to connect:

  • URL: Specify the URL of the GraphQL service;
  • Location: Set this to the file path containing the custom schemas defined earlier.

The driver supports two types of authentication:

  • Basic: Set AuthScheme to Basic. You must specify the User and Password of the GraphQL service.
  • OAuth 1.0 & 2.0: Please take a look at the Using OAuth Authentication section for detailed instructions.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7940