Skip to content

appStrategy's Blog

  • New item

Category: LDAP

appRules Connector Matrix 3.0

Below is the new appRules Connector Matrix:

www.appstrategy.com

The connectors/modules can be used in data integration, business rules and process automation projects.  They can be deployed on-premise or in the cloud.

Accounting

  • Exact Online
  • FreshBooks
  • Intacct
  • QuickBooks
  • QuickBooks Online
  • QuickBooks POS
  • Reckon *
  • Sage50 *
  • Sage50 UK
  • Xero

Analytics

  • Google Analytics
  • YouTube Analytics *

Big Data

  • Google BigQuery
  • HBase *
  • HPCC – LexisNexis

Cloud Storage

  • Azure Table Storage
  • Box *

Collaboration

  • Exchange
  • Google Apps
  • Office365
  • SharePoint
  • Smartsheet *

CRM

  • Dynamics CRM
  • NetSuite CRM
  • Salesforce
  • SugarCRM
  • ZohoCRM

Databases

  • Access
  • DB2
  • Firebird
  • Informix
  • MySQL
  • ODBC
  • OLEDB
  • Oracle
  • PostgreSQL
  • SQLite
  • SQL Azure
  • SQL Server
  • SQL Server Compact
  • Teradata
  • Vertica

Email

  • Email
  • GMail

Expense Management

  • Concur *

ERP

  • Dynamics AX *
  • Dynamics GP
  • Dynamics NAV
  • NetSuite ERP
  • SAP

Files

  • Delimited (CSV) File
  • Fixed Length File
  • File System

Financial

  • E*Trade *
  • OFX
  • PayPal *
  • Quandl *

Marketing

  • Eloqua
  • Google AdWords
  • HubSpot
  • MailChimp
  • Marketo

NoSQL

  • Cassandra
  • Couchbase
  • Amazon DynamoDB
  • MongoDB
  • Amazon SimpleDB

Payment Processing

  • Authorize.Net
  • Square

Project Management

  • Basecamp *
  • Microsoft Project

Services

  • Active Directory
  • JSON*
  • LDAP
  • OData
  • RSS
  • XML

Social

  • Facebook
  • LinkedIn *
  • Twitter

Spreadsheets

  • Excel
  • Excel Services
  • Google Sheets

* Beta (Coming Soon)

You can download appRules with sample projects at: http://www.appstrategy.com/appRulesTrial

Author appStrategy TeamPosted on July 18, 2016August 26, 2016Categories Access, Accounting, Active Directory, Amazon DynamoDB, Amazon SimpleDB, Analytics, Authorize.Net, Azure Table Storage, Basecamp, Big Data, Box, Business Rules, Cassandra, Cloud Deployment, Cloud Storage, Collaboration, Connectors, Couchbase, CRM, Data Integration, Data Quality, Databases, DB2, Delimited File (CSV), Deployment, Dynamics AX, Dynamics CRM, Dynamics GP, Dynamics NAV, E*Trade, Eloqua, Email, Email, ERP, ETL, ExactOnline, Excel, Excel Services, Exchange, Facebook, File System, Files, Financial, Firebird, Fixed Length File, Freshbooks, GMail, Google AdWords, Google Analytics, Google Apps, Google BigQuery, Google Sheets, HBase, HPCC - LexisNexis, HubSpot, Informix, Intacct, JSON, LDAP, LinkedIn, MailChimp, Marketing, Marketo, Microsoft Project, MongoDB, MySQL, NetSuite CRM, NetSuite ERP, NoSQL, OData, ODBC, Office 365, OFX, OLEDB, On-Premise Deployment, Oracle, Payment Processing, PayPal, PostgreSQL, Project Management, Quandl, QuickBooks, QuickBooks Online, QuickBooks POS, RSS, Sage50, Sage50 UK, Salesforce, SAP, Services, SharePoint, Social, Spreadsheets, SQL Server, SQL Server Compact, SQLAzure, SQLite, Square, SugarCRM, Teradata, Twitter, Vertica, Xero, XML, YouTube Analytics, ZohoCRM

Connecting all Data Sources from the same Module

In appRules, each module is packaged as a library that includes all the supported activities for the module.

Typically, when composing projects with appRules Studio, users include the required modules in the toolbox.  For example, if you are developing a project for exporting Salesforce or Dynamics CRM data to a Delimited File, you will add the CRM module and the Delimited File module to the toolbox.  During development, depending on your requirement, you drag and drop activities from the CRM and the Delimited File modules.

appRules 3.0 now includes the appRules BaseData module.  BaseData includes all the commonly used activities for all data sources including databases and files.  In other words, BaseData is the generic connector.

Using BaseData, you can still configure your data source as usual.  The only difference is that now you can select from all data sources instead of the specific data source.

BaseData Toolbox Activities

 

Activities in the BaseData library include the following:

  • Initialization/Closing of connections
  • Initialization/Closing of files
  • Lookups
  • Mapping
  • Replication
  • CRUD functionality
  • Viewers
  • Iteration

As shown above, the BaseData module includes activities with shared functionality between modules.  To utilize module-specific functionality (for example Assign in Dynamics CRM), you must include the target module in the toolbox.

 

Data Source Configuration

 

The BaseData Data Source configuration window supports selection and definition of any data source type.

 

BaseData Actions and Conditions

The BaseData activities are also exposed as Actions and Conditions under the Primitives category.  You can select any of the actions and conditions for use in Decision Tables, Rule Sets, Condition Evaluators, etc.

Actions

 

Conditions

 

Conclusion

The BaseData activity is a powerful new addition to the appRules toolbox.  It saves time during project development by consolidating most commonly used selections in one location regardless of data source type.

You can download appRules with sample projects at: http://www.appstrategy.com/appRulesTrial

Author appStrategy TeamPosted on July 9, 2016August 12, 2016Categories Access, Accounting, Active Directory, Amazon DynamoDB, Amazon SimpleDB, Analytics, Authorize.Net, Azure Table Storage, Basecamp, Big Data, Cassandra, Cloud Storage, Collaboration, Connectors, Couchbase, CRM, Databases, DB2, Delimited File (CSV), Dynamics CRM, Dynamics GP, Dynamics NAV, E*Trade, Eloqua, Email, Email, ERP, ExactOnline, Excel, Excel Services, Exchange, Facebook, Files, Financial, Firebird, Fixed Length File, Freshbooks, GMail, Google AdWords, Google Analytics, Google Apps, Google BigQuery, Google Sheets, HBase, HPCC - LexisNexis, HubSpot, Informix, Intacct, JSON, LDAP, MailChimp, Marketing, Marketo, Microsoft Project, MongoDB, MySQL, NetSuite CRM, NetSuite ERP, NoSQL, OData, ODBC, Office 365, OFX, OLEDB, Oracle, Payment Processing, PayPal, PostgreSQL, Project Management, Quandl, QuickBooks, QuickBooks Online, QuickBooks POS, RSS, Sage50, Sage50 UK, Salesforce, SAP, Services, SharePoint, Social, Spreadsheets, SQL Server, SQL Server Compact, SQLAzure, SQLite, Square, SugarCRM, Teradata, Twitter, Vertica, Xero, XML, ZohoCRMLeave a comment on Connecting all Data Sources from the same Module

Useful Links

  • appStrategy Web Site

Recent Posts

  • appRules Portal to be released at Innovation Expo on June 14, 2017
  • Orchestrating File Processing and Archiving Using appRules File Iteration Activities
  • Using appRules® to Implement Round Robin Lead and Incident Assignments in Dynamics CRM
  • Metadata-Driven Design for Business Rules & Data Integration
  • Business Rules 101: appRules Decision Tables for Beginners
  • appRules Connector Matrix 3.0
  • Managing and Synchronizing Parent/Child Workflows in appRules®
  • Replicate Cloud Platform Data Using the appRules® Data Replication Activity
  • appRules® Project Gallery : Supplier Evaluations
  • Extend Data Integration & Business Rules Projects Using Custom Functions

Join Us

  • View appRules’s profile on Facebook
  • View appstrategy’s profile on Twitter

Archives

Categories

  • Accounting (2)
    • ExactOnline (2)
    • Freshbooks (2)
    • Intacct (2)
    • QuickBooks (2)
    • QuickBooks Online (2)
    • QuickBooks POS (2)
    • Sage50 (2)
    • Sage50 UK (2)
    • Xero (2)
  • Analytics (2)
    • Google Analytics (2)
    • YouTube Analytics (1)
  • Big Data (2)
    • Google BigQuery (2)
    • HBase (2)
    • HPCC – LexisNexis (2)
  • Business Rules (9)
    • Actions & Conditions (1)
    • Decision Table (2)
    • Scoring and Rating (1)
  • Cloud Platform (3)
  • Cloud Storage (2)
    • Azure Table Storage (2)
    • Box (1)
  • Collaboration (2)
    • Exchange (2)
    • Google Apps (2)
    • Office 365 (2)
    • SharePoint (2)
  • Connectors (2)
  • CRM (8)
    • Dynamics CRM (6)
    • NetSuite CRM (3)
    • Salesforce (5)
    • SugarCRM (3)
    • ZohoCRM (3)
  • Data Integration (10)
  • Data Quality (1)
  • Data Replication (1)
  • Databases (6)
    • Access (4)
    • DB2 (4)
    • Firebird (3)
    • Informix (4)
    • MySQL (4)
    • ODBC (4)
    • OLEDB (4)
    • Oracle (4)
    • PostgreSQL (4)
    • SQL Server (4)
    • SQL Server Compact (4)
    • SQLAzure (4)
    • SQLite (3)
    • Teradata (4)
    • Vertica (3)
  • Deployment (2)
    • Cloud Deployment (2)
    • On-Premise Deployment (2)
  • Dynamics CRM (1)
  • Email (2)
    • Email (2)
    • GMail (2)
  • ERP (2)
    • Dynamics AX (1)
    • Dynamics GP (2)
    • Dynamics NAV (2)
    • NetSuite ERP (2)
    • SAP (2)
  • ETL (2)
  • Expressions And Functions (1)
    • C# (1)
    • Expressions (1)
    • Functions (1)
    • VB (1)
  • Files (6)
    • Delimited File (CSV) (4)
    • File System (2)
    • Fixed Length File (4)
  • Financial (2)
    • E*Trade (2)
    • OFX (2)
    • PayPal (2)
    • Quandl (2)
  • General (2)
  • Marketing (2)
    • Eloqua (2)
    • Google AdWords (2)
    • HubSpot (2)
    • MailChimp (2)
    • Marketo (2)
  • Metadata (1)
  • NoSQL (2)
    • Amazon DynamoDB (2)
    • Amazon SimpleDB (2)
    • Cassandra (2)
    • Couchbase (2)
    • MongoDB (2)
  • Payment Processing (2)
    • Authorize.Net (2)
    • Square (2)
  • Portal (1)
  • Project Gallery (1)
  • Project Management (2)
    • Basecamp (2)
    • Microsoft Project (2)
  • Services (2)
    • Active Directory (2)
    • JSON (2)
    • LDAP (2)
    • OData (2)
    • RSS (2)
    • XML (2)
  • Social (2)
    • Facebook (2)
    • LinkedIn (1)
    • Twitter (2)
  • Spreadsheets (3)
    • Excel (3)
    • Excel Services (2)
    • Google Sheets (2)
  • Studio (1)
  • Workflow (2)
  • New item
Cancel