The CData SSIS Components for HPCC models the data in your HPCC system as tables and stored procedures. The definitions of tables and stored procedures are dynamically retrieved, so that any changes to the HPCC system will immediately be reflected when you connect using the component.
The CData SSIS Components for HPCC uses the WsSQL Web service to interact with the underlying HPCC system. You will need to have WsSQL installed on the HPCC server. The component uses the WsSQL service to expose HPCC logical files as tables and HPCC record fields as table columns. The component exposes HPCC published queries as stored procedures.
The data model available through the component is completely dependent on the metadata methods of the WsSQL SOAP service. Refer to the WsSQL service's documentation to better understand the features and limitations of an HPCC system's data model.