SSIS Components for FinancialForce

Build 20.0.7656

Data Model

You can use the component to work with all of the tables in your account. The component connects to FinancialForce and gets the list of tables and the metadata for the tables by calling the appropriate web services. Any changes you make to your FinancialForce account, such as adding a new table, adding new columns, or changing the data type of a column, are immediately reflected when you connect using the component.


The component models the FinancialForce API as relational Tables. The table definitions are dynamically retrieved; here, we show the sample table definitions that are included in the development environment.

In addition to the tables, the component also offers stored procedures and views, enabling you to work with other aspects of the FinancialForce API, like bulk jobs, custom reports, and so on.

Stored Procedures

Stored Procedures are function-like interfaces to FinancialForce. They can be used to search, update, and modify information in FinancialForce.


Views offer additional metadata information from FinancialForce.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7656