To automate the tasks within a chain, each command uses a connector to interact with its data source. When you add a command to a chain, you enter the inputs required to perform its task. Your organization can set up connectors to interact with the Workiva platform and your other data sources.
If no connector is available for your data source, consider:
- If you can export the data as a file, save it to an online directory—such as in a Secure File Transfer Protocol (SFTP) server, Box®, Amazon® S3, or Google Drive®—and then retrieve it through the applicable connector.
- If your data source enables an HTTP application programming interface (API), retrieve the data through the HTTP Request connector.
Tip: If your data source enables an API or integration platform-as-a-service (iPaas), you can develop an integration with the Workiva API.
Core connectors
By default, your organization has several core connectors out-of-the-box:
- Workiva
- Data Prep, to apply sequences of transformations—called pipelines—to tabular outputs in chains
- Box
- Dell® Boomi®
- Encryption
- File Utilities
- Google Drive
- Handlebars
- HTTP Request
- Informatica®
- JSON
- Microsoft® Excel®
- Microsoft OneDrive®
Note: To connect to Microsoft SharePoint®, use a Microsoft OneDrive connector.
- Oracle Enterprise Performance Management (EPM) Utils
- Script Runner
- SnapLogic®
- Tabular Transformation
- XML
Premium connectors
In addition, your organization may have premium connectors available:
- Adaptive Insights®
- Amazon Redshift®
- Amazon S3
Note: To connect to Amazon Aurora®, use a MySQL or Postgres connector.
- Anaplan® Robotic Process Automation (RPA)
- Anaplan® (Standard)
- BlackLine® OAuth2
- Coupa@
- Domo®
- File Transfer Protocol Secure (FTPS)
- Google® BigQuery®
- Google® Cloud Storage
- IBM Db2®
- IBM® Planning Analytics TM1
- Java® Database Connectivity (JDBC)
- Microsoft Dynamics® CRM
- Microsoft® SQL Server®
- MySQL®
- Namely®
- NetSuite® Token Authentication
- NetSuite JDBC
- Oracle® Account Reconciliation Cloud Service (ARCS)
- Oracle Analytics Cloud (OAC)
- Oracle Content and Experience (OCE)
- Oracle Data Relationship Management (DRM)
- Oracle E-Business Suite (EBS)
- Oracle Enterprise Data Management Cloud Service (EDMCS)
- Oracle Essbase
- Oracle Financial Consolidation & Close Service (FCCS)
- Oracle Financial Data Quality Management, Enterprise Edition (FDMEE)
- Oracle Financials Cloud
- Oracle Human Capital Management (HCM)
- Oracle Hyperion Financial Management (HFM)
- Oracle Planning and Budgeting Cloud Service (PBCS) & Enterprise Planning and Budgeting Cloud Service (EPBCS)
- Oracle Profitability and Cost Management Service (PCMCS)
- Oracle Relational Database Management System (RDBMS) | Autonomous Data Warehouse (ADW)
- Oracle Transactional Business Intelligence (OTBI)
- Planful®
- Postgres
- Power BI®
- Prevedere®
- QuickBooks®
- Sage Intacct®
- Salesforce®
- SAP BAPI® RFC
- SAP® Business Warehouse
- SAP HANA® JDBC
- ServiceNow®
- SFTP
- Snowflake® JDBC
- Tableau®
- Trintech®
- UltiPro®
- VTS®
- Workday®