OLE DB Reporting Provider The ACT! OLE DB Reporting Provider is a data source provider written by Sage and is included with ACT!, ACT! Premium and ACT! Corporate Edition (includes ACT! Premium and ACT! Premium for Web).

The four Data Access Methods each offer a very different approach and data exposure. Such a case might include the need to perform unconstrained data rollups to a company or corporate level for consolidated reporting or other analytics. Depending upon the task, data security may or may not be of concern. Data Access Overview While the ACT! Report Designer offers a fairly comprehensive ability of creating custom reports and other correspondence, it can be limited in some aspects. This includes data extraction to consolidated databases for rollup, as well as highly-customized reports using thirdparty software such as Crystal Reports. These methods can be used for querying, reporting and data extraction: ACT! OLE DB Reporting Provider ACT! Reader Utility and account (ACT! Premium only) ACT! Password Utility (ACT! Premium only) ACT! SDK (Software Developers Kit) The objective of providing these additional methods outside of the ACT! application is to offer the user the most flexibility in creating reports, lists or other documents to suit most any need. In addition to Report Templates, the ACT! architecture provides four additional Data Access Methods. Template customization 1 is performed by the user right from within the application using the ACT! Report Designer. These items are based upon templates which can be further modified or copied to create a customized and specific solution as needed.

v2.0 Comparison ACT! Reporting and Data Access 2ģ Introduction The ACT! application provides its own Report Writer that offers a number of stock Reports, Envelopes and Labels which allow users to produce a variety of reports and correspondence. 8 ACT! Password ACT! Software Developers Kit CONCLUSION Recommendations Data Access Method Comparison Terms and Concepts OLE DB v1.0 vs. 1 Whitepaper Reporting and Data Access Methods ACT! by Sage Product FamilyĢ Table of Contents Introduction.

Act by sage user manual