Overview
The Lyftron Provider for AvaTax offers the most natural way to access AvaTax data from Lyftron with ease and also enables to connect with BI, MDM & ML tools, Data warehouses, Databases and other SAAS based applications with zero code and zero infrastructure requirements. The provider wraps the complexity of accessing AvaTax data into easy-to-integrate relational fully managed ANSI Sql format. Make faster and better business decisions with Lyftron’s AvaTax data provider and automatically build your data migration pipelines in minutes, not months
The provider hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.
Key Features
- Comprehensive Delta load mechanism.
- Real-time access to AvaTax.
- Comprehensive full support of ANSI Sql to query data with ease.
- Collaborative query processing.
Prerequisites
The user must have credentials for AvaTax, Lyftron and your destination data warehouse, lake or database to perform the data pipeline operation with Lyftron
Establishing a Connection with Lyftron's Quickstart Steps
Create your AvaTax connection with Lyftron by following the 5 easy steps show below:
Step1. Add your connection
Click on Connect section on the left panel → Click on Add Connection button
Step2. Select your connector
In the connector selection panel, search and click AvaTax for your connection
Step3. Enter your connection details
In the Connection String section enter the values of the below parameters. The following connection string is required to establish AvaTax connection with Lyftron.
"User=MyUser;Password=MyPassword;"| Key | Value | Field |
| Connection Name | Enter your connection details | Required |
| User | Your AvaTax User | Required |
| Password | Your AvaTax Password | Required |
| Logfile** | Use the logfile option to debug your job and provide your connection name to generate the log file. [ConnectionConfigurationPath]\Connection_name_log.tx | Optional |
| Verbosity** | Choose verbosity 1-5 based on the severity of debugging | Optional |
** For more information, check the Lyftron logging and debugging section.
If you want more detailed information about how to establish a connection with Lyftron, click on Lyftron Connection Quick Start guide.
Step4. Test your connection
Once you are done entering your connection details, simply click on the Test Connection button to test the connectivity. In case your connection fails, add Logfile and Verbosity parameters and check the Lyftron logging and debugging section, to debug the error.
Step5. Save your connection
Hurray! Now you have successfully connected with the Lyftron AvaTax connector and can utilize the connector to Extract, Warehouse, Analyze, Visualize and Share your data.
Data Model
This section shows the available API objects and provides more information on executing SQL to Avalara Avatax APIs.
Key Features
- The provider models Avalara Avatax entities as relational views, allowing you to write SQL to query Avalara Avatax data.
- Stored procedures allow you to execute operations to Avalara Avatax.
- Live connectivity to these objects means any changes to your Avalara Avatax account are immediately reflected when using the provider.
Tables
Tables describes the available tables. Tables are statically defined to model Accounts, Transactions, Users, and more.
Views
Views describes the available views. Views are statically defined to model Reports, Subscriptions, and more.
| Name | Type | Description |
| Accounts | Tables | Accounts table for AvalaraAvatax data provider. |
| Batches | Tables | Batches table for AvalaraAvatax data provider. |
| Companies | Tables | Companies table for AvalaraAvatax data provider. |
| Contacts | Tables | Contacts table for AvalaraAvatax data provider. |
| Customers | Tables | Customers table for AvalaraAvatax data provider. |
| DataSources | Tables | DataSources table for AvalaraAvatax data provider. |
| DistanceThresholds | Tables | DistanceThresholds table for AvalaraAvatax data provider. |
| FilingCalendars | Tables | FilingCalendars table for AvalaraAvatax data provider. |
| Items | Tables | Items table for AvalaraAvatax data provider. |
| Locations | Tables | Locations table for AvalaraAvatax data provider. |
| MultiDocument | Tables | MultiDocument table for AvalaraAvatax data provider. |
| Nexus | Tables | Nexus table for AvalaraAvatax data provider. |
| Notices | Tables | Notices table for AvalaraAvatax data provider. |
| Notifications | Tables | Notifications table for AvalaraAvatax data provider. |
| Settings | Tables | Settings table for AvalaraAvatax data provider. |
| TaxCodes | Tables | TaxCodes table for AvalaraAvatax data provider. |
| TaxRules | Tables | TaxRules table for AvalaraAvatax data provider. |
| TransactionLines | Tables | TransactionLines view for AvalaraAvatax data provider. |
| Transactions | Tables | Transactions table for AvalaraAvatax data provider. |
| Upcs | Tables | Upcs table for AvalaraAvatax data provider. |
| Users | Tables | Users table for AvalaraAvatax data provider. |
| BatchFiles | Views | BatchFiles view for AvalaraAvatax data provider. |
| CustomerCustomFields | Views | CustomerCustomFields view for AvalaraAvatax data provider. |
| CustomerExposureZones | Views | CustomerExposureZones view for AvalaraAvatax data provider. |
| FilingCalendarAvailablePOA | Views | FilingCalendarAvailablePOA view for AvalaraAvatax data provider. |
| ItemClassifications | Views | ItemClassifications view for AvalaraAvatax data provider. |
| ItemParameters | Views | ItemParameters view for AvalaraAvatax data provider. |
| LocationSettings | Views | LocationSettings view for AvalaraAvatax data provider. |
| Nexus | Views | Nexus table for AvalaraAvatax data provider. |
| NoticeComments | Views | NoticeComments view for AvalaraAvatax data provider. |
| NoticeFinances | Views | NoticeFinances view for AvalaraAvatax data provider. |
| NoticeResponsibility | Views | NoticeResponsibility view for AvalaraAvatax data provider. |
| NoticeRootCause | Views | NoticeRootCause view for AvalaraAvatax data provider. |
| ReportParameters | Views | ReportParameters view for AvalaraAvatax data provider. |
| Reports | Views | Reports table for AvalaraAvatax data provider. |
| Subscriptions | Views | Subscriptions table for AvalaraAvatax data provider. |
| TransactionAddresses | Views | TransactionAddresses view for AvalaraAvatax data provider. |
| TransactionInvoiceMessages | Views | TransactionInvoicemessages view for AvalaraAvatax data provider. |
| TransactionLocationTypes | Views | TransactionLocationTypes view for AvalaraAvatax data provider. |
| TransactionMessages | Views | TransactionMessages view for AvalaraAvatax data provider. |
| TransactionParameters | Views | TransactionParameters view for AvalaraAvatax data provider. |
| TransactionSummary | Views | TransactionSummary view for AvalaraAvatax data provider. |
| TransactionTaxDetailsByTaxType | Views | TransactionTaxdetailsbytaxtype view for AvalaraAvatax data provider. |
Advanced Settings
To view a detailed advanced settings options, go to AvaTax Advanced Settings. Complete list of the parameters you can configure in the connection string can be found by clicking Connection String Parameters.