2018 Scribe User Conference | Oct 28-30th | Register Today >

Scribe

NetSuite (CData)

Scribe has partnered with CData, which offers drivers with connectivity to many business applications. This connector gives you full access to the capabilities of the CData driver for NetSuite, including more than one hundred NetSuite CRM and ERP entities. Integrate NetSuite with CRM systems like Salesforce, Dynamics 365 and SugarCRM; marketing automation systems such as Marketo, Oracle Eloqua, and Pardot; or eCommerce platforms like Magento and Shopify.

Marketing automation to NetSuite possibilities:

  • Creating leads in NetSuite when you convert visitors on your website
  • Tracking activities such as email click-through and webinar attendance

CRM to NetSuite ERP integrations:

  • Sync customer address, phone and email details
  • Automate sales order processing
  • Make invoice data available to salespeople in your CRM

eCommerce to NetSuite options:

  • Sync inventory and product details from NetSuite to your storefront
  • Automatically move orders from your eCommerce platform to NetSuite for processing
  • Make shipping information from NetSuite visible to your customers in your web store

Technical Benefits:

  • Create, read, update and delete more than 100 entities in NetSuite
  • Batch create, update and delete operations for better performance
  • Support for custom objects and fields
  • Native query for complex joins and filtering
  • Works with on-premise and cloud agents

Resources:

Oracle Sales Cloud

Shopify

Apache HBase

REST

Representational State Transfer (REST) is an architectural style that has become the dominant approach for constructing web APIs. REST consists of a set of guidelines or constraints. It is not a standard, which makes it difficult to say for sure whether an API is RESTful or not. Until recently there was no standard way to describe a RESTful API and therefore no standard way to connect to one. Connecting meant coding, but that has changed.

The OpenAPI Specification (aka Swagger 2.0) provides a uniform description of RESTful APIs that machines can read and understand. Scribe’s REST Connector reads an API definition in an OpenAPI Specification document to understand how to interact with a RESTful API, including authentication and discovery of metadata and operations.

If you use a cloud application that offers an OpenAPI Specification for its API, the REST Connector can connect directly to it without coding a custom connector. Simply import the OpenAPI Specification into the connection definition, and Scribe does the rest. That isn’t the only scenario, however.

As part of their digital transformation initiatives, many enterprises are adding a REST API layer on top of legacy applications using API Management tools. Most of these tools provide OpenAPI Specifications for the new APIs. This allows the REST Connector to interact with legacy applications. With Scribe Online, you can integrate legacy ERP, HR or other applications with cloud applications like Salesforce, Dynamics 365 and Marketo.

Even if the application you want to connect has no OpenAPI Specification, you can write your own for use with the REST Connector.

Technical Benefits:

  • Connect to RESTful APIs using an OpenAPI Specification
  • Authentication methods: none, basic, API key or OAuth 2.0 Client Credentials Grant
  • Supports standard REST operations: GET, POST, PUT and DELETE
  • Works with on-premise and cloud agents

Resources:

Microsoft Dynamics NAV

Microsoft Dynamics CRM

Google Analytics

Companies around the world use Google Analytics to understand their web traffic, from the number of visitors to how long people spend on the site and where they exit. Google provides a reporting environment in which to analyze the data, but in some cases, you want to copy your data out of Google Analytics to somewhere else. This connector allows you to do just that.

Scribe has partnered with CData, which offers drivers with connectivity to more than a hundred applications. This connector uses the CData driver for Google Analytics to get data about your websites and send it to a database or business application.

You can use the Scribe Connector for Google Analytics to:

  • Copy Google Analytics data to a Microsoft SQL Server, MySQL, Oracle or PostgreSQL database and analyze it with tools like Microsoft Power BI or Tableau
  • Record goal completions from Google Analytics in a CRM system like Salesforce or Dynamics 365
  • Backup Google Analytics data to a database or text files

Technical Benefits:

  • Authenticate via OAuth
  • Query objects including AdWords, ecommerce, events, goal completions, traffic and more
  • Supports native query for joining tables and filtering query results

Resources:

Oracle Database

The Oracle Database connector enables you to integrate Oracle with your business applications. Connect Oracle to CRM systems like Dynamics 365, Salesforce and SugarCRM. Integrate with ERP systems like Dynamics, NetSuite and SAP. Sync with marketing automation systems like Salesforce Marketing Cloud, Oracle Eloqua and Marketo.

You can use the Oracle Database connector to:

  • Integrate applications that use an Oracle Database back end with CRM, ERP, or marketing automation apps
  • Replicate data from your Salesforce or Dynamics 365 CRM system to an Oracle Database for backup or analytics
  • Migrate data from an on-premise Oracle Database to the cloud

Technical Benefits:

  • Authentication based on username and password
  • Filter the list of tables when creating a connection
  • Automatically discover tables, fields and data types
  • Query, create, update and delete data
  • Native query allows you to write your own free-form query to join tables, restrict source field lists, or customize the WHERE clause
  • Process records in batches for higher performance
  • Scalar functions and nonquery

Resources:

PostgreSQL

Scribe has partnered with CData, which offers drivers with connectivity to more than a hundred applications. This connector uses the CData driver for PostgreSQL to integrate data stored in a PostgreSQL database with any of your business applications, including Salesforce, Microsoft Dynamics 365, Pardot, HubSpot, Marketo, Oracle Eloqua and more.

You can use the Scribe Connector for PostgreSQL to:

  • Access data for an application that uses PostgreSQL as a data store
  • Automatically copy data from one or more business applications to PostgreSQL for reporting
  • Migrate data from an on-premise PostgreSQL database to the cloud

Technical Benefits:

  • Authentication based on username and password
  • Automatically discover tables, fields and data types
  • Query, create, update and delete data in a PostgreSQL database
  • Supports native SQL queries for flexibility in joining tables, filtering and many other capabilities

Resources:

cleverbridge

With the cleverbridge connector for Scribe Online, you can integrate your payment and subscription information with your other business systems, including CRM, ERP and marketing automation. Automate manual processes to reduce data entry errors and grow your business to the next level.

Business Benefits:

  • Sync customer payment events with CRM systems like Salesforce, Dynamics 365 and SugarCRM so your sales team has the latest information and can contact customers when appropriate
  • Send subscription payment details to your accounting or ERP system to ensure that your finance team is working with the most up-to-date information
  • Use a marketing automation system like Marketo or Eloqua to communicate subscription information such as upcoming renewals to your customers

 Technical Benefits:

  • Receive outbound notifications from cleverbridge for real-time integration using message maps in Scribe Online
  • Work with contacts, purchases and subscriptions
  • Source and target operations
  • Cloud and on-premise agents

Resources:

Scribe Labs – Microsoft Excel

Use the Scribe Labs — Microsoft Excel Connector to read and write MS Excel (.xls, .xlsx) and comma delimited (.csv) files. This Connector is designed for easy read/write access to on-premise Excel and CSV file data sources without needing to install MS Excel on the On- Premise Agent server. Metadata for the files is automatically generated from the header row of each file.

For more information:
Help & Documentation >

Scribe Labs – Variables

This Connector extends the functionality of Scribe Online. It adds a component to store and retrieve variables (as key/value pairs) within Scribe Maps. The variables are stored in memory and are non-persistent. They have global scope within a Map, but are not shared between Maps or Solutions.

For more information:
Help & Documentation >

Scribe Labs – Tools

The Tools Connector provides special operations that can be used as entities in the Execute Block in your Scribe Online Maps to enhance the performance of the Map or provide diagnostic information.

For more information:
Help & Documentation >

ServiceNow

The ServiceNow connector allows you to connect your IT service management application to other business systems like Salesforce and Microsoft Dynamics 365 to automate the flow of data.

Business Benefits:

  • Maintain a single incident database by integrating your front office systems with ServiceNow.
  • Easily track service requests and resolutions via automated data syncing between ServiceNow and your other systems.
  • Create work orders and tasks after winning an opportunity in CRM.

Technical Benefits:

  • Create, read, update and delete data in ServiceNow
  • Table Filter improves performance by including only objects you want to access
  • Support for custom objects
  • Works with on-premise and cloud agents

Resources:

Let Us Help You<br />Find a Solution

Let Us Help You
Find a Solution

Move Faster. Work Smarter. Be Ready. Our platforms are designed for you.

Contact Scribe
Watch A Demo <br />of Scribe Online

Watch A Demo
of Scribe Online

Scribe Online Integration Service (IS)
Overview Demo.

View Demo
Take Our Platforms<br />for  a Spin

Take Our Platforms
for a Spin

Experience it yourself – power,
speed, simplicity, and more.

Try Our Software