Saltar al contenido principal Saltar al contenido complementario

SaaSOptics 

SaaSOptics is a subscription management platform that automates financial operations for growing B2B SaaS businesses.

SaaSOptics integration replicates data using the SaaSOptics REST API.

See the Schema section for a list of objects available for replication.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Nota informativaAsegúrese de que la cuenta que utiliza tenga acceso de lectura a las tablas que desea recuperar.

Creating the connection

Para más información, vea Conexión a aplicaciones SaaS.

  1. Rellene las propiedades de conexión necesarias.
  2. Proporcione un nombre para la conexión en Nombre de la conexión.

  3. Seleccione Abrir metadatos de conexión para definir metadatos para la conexión cuando se haya creado.

  4. Haga clic en Crear.

Connection settings
SettingDescription
Data gateway

Seleccione una Data Movement gateway si su caso de uso así lo requiere.

Nota informativa

Este campo no está disponible con la suscripción Qlik Talend Cloud Starter porque Data Movement gateway no se admite. Si tiene otro nivel de suscripción y no desea utilizar Data Movement gateway, seleccione Ninguna.

Para obtener información sobre las ventajas de Data Movement gateway y los casos de uso que lo requieren, consulte Pasarela de movimiento de datos de Qlik.

Start Date

Indique la fecha, en el formato MM/DD/YYYY, a partir de la cual deben replicarse los datos de su fuente a su destino.

Account NameAccount Name.
Server SubdomainServer subdomain. You can find it in the URL of your account homepage. If the URL is https://mycompany.saasoptics.com/, the subdomain is mycompany.
TokenAPI token.
Date Window SizeThe size of the date window for retrieving data.

Schema

Nota informativa

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

The schema and info displayed below is for version 1.

Depending on your destination, table and column names may not appear as they are outlined below.

accounts

The accounts table contains info about accounts, or records in your Chart of Accounts, in SaaSOptics.

Replication Method

Full Table

Primary Key

id

Useful links

SaaSOptics API method

auto_renewal_profiles

The auto_renewal_profiles table contains info about auto-renwal profiles, or transaction renewal rules in your SaaSOptics account.

Replication Method

Full Table

Primary Key

id

Useful links

SaaSOptics API method

billing_descriptions

The billing_descriptions table contains info about billing line item descriptions.

Replication Method

Full Table

Primary Key

id

Useful links

SaaSOptics API method

billing_methods

The billing_methods table contains info about billing methods, which are used to specify billing/invoice frequencies for transactions in your SaaSOptics account.

Replication Method

Full Table

Primary Key

id

Useful links

SaaSOptics API method

contracts

The contracts table contains info about the contracts in your SaaSOptics account.

Replication Method

CDC

Primary Key

id

Replication Key

modified

Useful links

SaaSOptics API method

country_codes

The country_codes table contains info about country codes.

Replication Method

Full Table

Primary Key

id

Useful links

SaaSOptics API method

currency_codes

The currency_codes table contains info about currency codes.

Replication Method

Full Table

Primary Key

code

Useful links

SaaSOptics API method

customers

The customers table contains info about customers.

Replication Method

CDC

Primary Key

id

Replication Key

modified

Useful links

SaaSOptics API method

deleted_contracts

The deleted_contracts table contains a list of deleted SaaSOptics contracts.

Replication Method

CDC

Primary Key

id

Replication Key

deleted

Useful links

deleted_invoices

The deleted_invoices table contains a list of deleted SaaSOptics invoices.

Replication Method

CDC

Primary Key

id

Replication Key

deleted

Useful links

deleted_revenue_entries

The deleted_revenue_entries table contains a list of deleted SaaSOptics revenue entries.

Replication Method

CDC

Primary Key

id

Replication Key

deleted

Useful links

deleted_transactions

The deleted_transactions table contains a list of deleted SaaSOptics transactions.

Replication Method

CDC

Primary Key

id

Replication Key

deleted

Useful links

invoices

The invoices table contains info about invoices in your SaaSOptics account.

Replication Method

CDC

Primary Key

id

Replication Key

auditentry_modified

Useful links

SaaSOptics API method

items

The items table contains info about items, which are products and services you sell.

Replication Method

CDC

Primary Key

id

Replication Key

modified

Useful links

SaaSOptics API method

payment_terms

The payment_terms table contains info about invoice payment terms.

Replication Method

Full Table

Primary Key

id

Useful links

SaaSOptics API method

registers

The registers table contains info about registers, which can contain one or more contracts.

Replication Method

CDC

Primary Key

id

Replication Key

modified

Useful links

SaaSOptics API method

revenue_entries

The revenue_entries table contains info about revenue entries.

Replication Method

CDC

Primary Key

id

Replication Key

modified

Useful links

SaaSOptics API method

revenue_recognition_methods

The revenue_recognition_methods table contains info about revenue recognition methods, which are the methods for calculating and generating revenue records for a transaction.

Replication Method

Full Table

Primary Key

id

Useful links

SaaSOptics API method

sales_orders

The sales_orders table contains info about sales orders, which have historically been synced in through the Salesforce integration and processed into financial records within SaaSOptics.

Replication Method

CDC

Primary Key

id

Replication Key

created

Useful links

SaaSOptics API method

transactions

The transactions table contains info about transactions.

Replication Method

CDC

Primary Key

id

Replication Key

modified

Useful links

SaaSOptics API method

¿Esta página le ha sido útil?

Si encuentra algún problema con esta página o su contenido (errores tipográficos, pasos que faltan o errores técnicos), no dude en ponerse en contacto con nosotros.