DataSelf Knowledge Base

DataSelf ETL+ — Connects to diverse data sources and populates the data warehouse. ETL+ User Guide.

DataSelf Analytics — Ready-to-use Business Intelligence solutions for your ERP and CRM. Leverages the ETL+ engine to supply preconfigured templates with sophisticated insights for your business.

Tableau — Tableau for data querying and retrieval, report generation, and dashboard creation. IncludesTableau configuration, security, upgrade procedures, and technical tips for optimizing implementation.

KPIs, Reports & Dashboards — How to create Key Performance Indicators & Metrics that incorporate into reports and dashboards.

• Power BI

• Microsoft Excel.

• Supported Data Sources

DataSelf Training – Class Notes and handouts ✍️ 🆕
White belt | Green belt | Orange belt | Blue belt | Register for training 

Upgrading your ETL+ 📡 v2023.07

• ETL+ User Guide

• Automatic Distribution – DSA AD,
  DSA Cloud AD, Excel AD

• PowerShell

DataSelf Agent for scheduling ETL+ refresh jobs

DataSelf for ERP, CRM and other business systems

Pre-configured templates listed by business system.

ETL+ Source Drivers

Data Sources supported by DataSelf.

• ActiveCampaign: ODBC.

• Acumatica CRM: Native optimized connection.

• Acumatica ERP: Native optimized connection.

• Acumatica MRP: Native optimized connection.

• Acumatica Cloud OData v3: Native optimized connection.

• Acumatica Cloud OData v4: Native optimized connection.

• Acumatica MS SQL Server: Native optimized connection.

• Acumatica MySQL: Native optimized connection.

• Adobe Analytics: ODBC.

• Adobe Commerce: ODBC.

• ADP: ODBC.

• AfterShip: ODBC.

• Ahrefs: ODBC.

• Airtable: ODBC.

• AlloyDB: ODBC.

• Amazon Athena: ODBC.

• Amazon Aurora: ODBC.

• Amazon DynamoDB: ODBC.

• Amazon EMR Hive: ODBC.

• Amazon Marketplace: ODBC.

• Amazon Redshift: ODBC.

• Amazon S3: ODBC.

• Apache Cassandra: ODBC.

• Apache Hive: ODBC.

• Apache Impala: ODBC.

• Apache Spark SQL: ODBC.

• Asana: ODBC.

• ASE: ODBC.

• Authorize.Net: ODBC.

• Avalara AvaTax: ODBC.

• Avro: ODBC.

• Basecamp: ODBC.

• BigCommerce: ODBC.

• Bing Ads: ODBC.

• Bing Search: ODBC.

• Blackbaud FE NXT: ODBC.

• Box: ODBC.

• Bugzilla: ODBC.

• Bullhorn CRM: ODBC.

• Cassandra: ODBC.

• Certinia: ODBC.

• Cin7 Core: ODBC.

• ClickUp: ODBC.

• Cloudant: ODBC.

• Cloudera CDH Hive: ODBC.

• CockroachDB: ODBC.

• Confluence: ODBC.

• Cosmos DB: ODBC.

• Couchbase: ODBC.

• CouchDB: ODBC.

• CSV (text file): Native optimized connection.

• CYMA: ODBC.

• Databricks: ODBC.

• DataStax: ODBC.

• DB2: ODBC.

• dBase: ODBC.

• Dear Inventory: ODBC.

• Delighted: ODBC.

• Device42: ODBC.

• DocuSign: ODBC.

• Dropbox: ODBC.

• eBay: ODBC.

• Ebay Analytics: ODBC.

• Elasticsearch: ODBC.

• Email: ODBC.

• Email Octopus: ODBC.

• EnterpriseDB: ODBC.

• Epicor: ODBC.

• Epicor Kinetic: ODBC.

• Exact Online: ODBC.

• Facebook: ODBC.

• Facebook Ads: ODBC.

• FedEx: ODBC.

• FHIR: ODBC.

• FinancialForce: ODBC.

• Firebird: ODBC.

• Freshbooks: ODBC.

• FreshdeskAds: ODBC.

• Freshsales: ODBC.

• Freshworks CRM: ODBC.

• Freshservice: ODBC.

• FTP: ODBC.

• GitHub: ODBC.

• Gmail: ODBC.

• Global Shop Solutions (GSS): Optimized ODBC connection for Pervasive database.

• Google Ad Manager: ODBC.

• Google Ads: ODBC.

• Google AdSense: ODBC.

• Google Analytics: ODBCand Python.

• Google Analytics 4: ODBC.

• Google BigQuery: ODBC.

• Google Calendar: ODBC.

• Google Campaign Manager: ODBC.

• Google Cloud Storage: ODBC.

• Google Contacts: ODBC.

• Google Data Catalog: ODBC.

• Google Directory: ODBC.

• Google Drive: ODBC.

• Google Search: ODBC.

• Google Sheets: Native optimized connection.

• Google Spanner: ODBC.

• GraphQL: ODBC.

• Greenplum: ODBC.

• Greentree: ODBC.

• HarperDB: ODBC.

• HBase: ODBC.

• HCL Domino: ODBC.

• HDFS: ODBC.

• Heroky Postgres: ODBC.

• Highrise: ODBC.

• Hive: ODBC.

• Hortonworks Hive: ODBC.

• HubSpot: ODBC.

• IBM BigInsights: ODBC.

• IBM Cloud Data Engine: ODBC.

• IBM Cloud Object Storage: ODBC.

• IBM Db2: ODBC.

• IBM Db2 Warehouse on Cloud: ODBC.

• IBM Informix: ODBC.

• Impala: ODBC.

• Infor CRM: Native optimized connection to MS SQL Server.

• Infor ERP: ODBC.

• Instagram: ODBC.

• Interbase: ODBC.

• JAMIS Prime OData v3: Native optimized connection.

• JAMIS Prime OData v4: Native optimized connection.

• Jira: ODBC.

• Jira Service Desk: ODBC.

• Jira Service Management: ODBC.

• JSON: ODBC.

• Kintone: ODBC.

• Klaviyo: ODBC.

• LDAP: ODBC.

• LinkedIn: ODBC.

• LinedIn Ads: ODBC.

• Macola: Native optimized connection to MS SQL Server.

• Mangento: ODBC.

• MailChimp: ODBC.

• Mailjet: ODBC.

• MapR Hive: ODBC.

• MariaDB: ODBC.

• Marketo: ODBC.

• MarkLogic: ODBC.

• Microsoft Access: Native optimized connection.

• Microsoft Active Directory: ODBC.

• Microsoft Azure Entra: ODBC.

• Microsoft Azure Analysis Services: ODBC.

• Microsoft Azure Billing: ODBC.

• Microsoft Azure Compute: ODBC.

• Microsoft Azure Data Catalog: ODBC.

• Microsoft Azure Data Lake Storage: ODBC.

• Microsoft Azure DevOps: ODBC.

• Microsoft Reserved Virtual Machine: ODBC.

• Microsoft Resource Health: ODBC.

• Microsoft Azure SQL: Native optimized connection.

• Microsoft Azure Synapse: ODBC.

• Microsoft Azure Synapse Analytics: ODBC.

• Microsoft Azure Table: ODBC.

• Microsoft Dataverse: ODBC.

• Microsoft Dynamics 365 Business Central (BC, NAV): Native optimized connection to MS SQL Server.

• Microsoft Dynamics 365 F&O: Native optimized connection to MS SQL Server.

• Microsoft Dynamics 365 CRM: Native optimized connection to MS SQL Server.

• Microsoft Dynamics 365 GP (Great Plains): Native optimized connection to MS SQL Server.

• Microsoft Dynamics 365 NV (Navision): ODBC.

• Microsoft Dynamics 365 SL: Native optimized connection to MS SQL Server.

• Microsoft Excel: Native optimized connection.

• Microsoft Excel Online: ODBC.

• Microsoft Exchange: ODBC.

• Microsoft Fabric: Contact us.

• Microsoft Fabric Data Warehouse: Contact us.

• Microsoft Fabric Lakehouse: Contact us.

• Microsoft FoxPro: ODBC.

• Microsoft Office 365: ODBC.

• Microsoft OneDrive: ODBC.

• Microsoft OneNote: ODBC.

• Microsoft Planner: ODBC.

• Microsoft Power BI XMLA: ODBC.

• Microsoft Project: ODBC.

• Microsoft SharePoint: ODBC.

• Microsoft SharePoint Excel Services: ODBC.

• Microsoft SQL Analysis Services: ODBC.

• Microsoft SQL Server: Native optimized connection.

• Microsoft Teams: ODBC.

• Monday.com: ODBC.

• MongoDB: ODBC.

• MYOB Accounting Right: ODBC.

• MySQL: Native optimized connection.

• nCino: ODBC.

• Neo4J: ODBC.

• NetSuite: Requires Suite Analytics enabled. See ODBC.

• NexusDB: ODBC.

• OData: Native connection.

• ODBC: Select the proper ODBC driver and follow the instructions.

• Odoo: ODBC.

• Oracle: Native optimized connection.

• Oracle Autonomous Data Warehouse: ODBC.

• Oracle CX Service: ODBC.

• Oracle Eloqua: ODBC.

• Oracle Financials Cloud: ODBC.

• Oracle HCM Cloud: ODBC.

• Oracle Sales: ODBC.

• Oracle SCM: ODBC.

• Oracle Services Cloud: ODBC.

• Outreach.io: ODBC.

• Parquet: ODBC.

• Paychex: CSV / Excel.

• Paylocity: ODBC.

• Paypal: ODBC.

• Pervasive SQL: ODBC.

• Phoenix: ODBC.

• Pinterest: ODBC.

• Pipedrive: ODBC.

• Pivotal HD: ODBC.

• Pivotal HDB: ODBC.

• Podio: ODBC.

• PostgreSQL: Native optimized connection.

• Presto: ODBC.

• Procore: Native optimized connection to MS SQL Server.

• Progress OpenEdge: ODBC.

• Providex: Optimized ODBC connection

• QMetry: ODBC.

• QuestDB: ODBC.

• Quora Ads: ODBC.

• Quickbase: ODBC.

• Quickbooks: ODBC.

• QuickBooks Desktop: ODBC.

• Quickbooks Enterprise: ODBC.

• Quickbooks Online: ODBC.

• Quickbooks Payments: ODBC.

• Quickbooks POS: ODBC.

• Raisers Edge NXT: ODBC.

• Reckon: ODBC.

• Reckon Accounts Hosted: ODBC.

• Redis: ODBC.

• REST: ODBC.

• RSS: ODBC.

• Sage 100: ODBC.

• Sage 100 MS SQL Server: Native optimized connection to MS SQL Server.

• Sage 100 Providex: Optimized ODBC connection.

• Sage 200: ODBC.

• Sage 300: ODBC.

• Sage 300 MS SQL: Native optimized connection to MS SQL Server.

• Sage 300 Pervasive: Optimized ODBC connection.

• Sage 50: Optimized ODBC connection.

• Sage 500: Native optimized connection to MS SQL Server.

• Sage Business Cloud Accounting: ODBC.

• Sage Cloud Accounting: ODBC.

• Sage CRE: ODBC.

• Sage CRM: Native optimized connection to MS SQL Server.

• Sage Intacct: ODBC.

• Sage Pro: ODBC.

• Sage Timberline: ODBC.

• Sage X3: Native optimized connection to MS SQL Server.

• Salesforce CRM: ODBC.

• Salesforce Chatter: ODBC.

• Salesforce Einstein: ODBC.

• Salesforce Marketing: ODBC.

• Salesforce Marketing Cloud Acct Eng: ODBC.

• Salesforce MC: ODBC.

• Salesforce Pardot: ODBC.

• Salesloft: ODBC.

• SAP: ODBC.

• SAP Ariba Procurement: ODBC.

• SAP Ariba Source: ODBC.

• SAP Business One: ODBC.

• SAP Business Objects BI: ODBC.

• SAP ByDesign: ODBC.

• SAP BW/4HANA: ODBC.

• SAP Concur: ODBC.

• SAP Fieldglass: ODBC.

• SAP HANA: ODBC.

• SAP HANA XS Advanced: ODBC.

• SAP Hybrids C4C: ODBC.

• SAP Netweaver Gateway: ODBC.

• SAP S/4HANA Cloud: ODBC.

• SAP Success Factors: ODBC.

• SAP Sybase ASE: ODBC.

• SAP Sybase IQ: ODBC.

• SAS Data Sets: ODBC.

• SAS xpt: ODBC.

• SellerCloud Ecommerce: Python.

• Semrush: ODBC.

• Sendgrid: ODBC.

• SendGrid: ODBC.

• Sendinblue: ODBC.

• SequeLink: ODBC.

• ServiceNow: ODBC.

• SFTP: ODBC.

• Shippo: ODBC.

• ShipStation: ODBC.

• Shopify: ODBC and Python.

• SingleStore: ODBC.

• Slack: ODBC.

• SmartSheet: ODBC.

• Snapchat Ads: ODBC.

• Snowflake: ODBC.

• Spark: ODBC.

• Splunk: ODBC.

• SQLite: ODBC.

• Square: ODBC.

• Starburst: ODBC.

• Streak: ODBC.

• Stripe: ODBC.

• Sugar CRM: ODBC.

• SuiteCRM: ODBC.

• SurveyMonkey: ODBC.

• Sybase: ODBC.

• Sybase IQ: ODBC.

• Tableau CRM Analytics: ODBC.

• Tableau Data Source: Python.

• Tableau Server: Python.

• Tally: ODBC.

• TaxJar: ODBC.

• TeamCity: ODBC.

• TeamWork: ODBC.

• Teradata: ODBC.

• Text Files (CSV): Native optimized connection.

• Tier1: ODBC.

• TigerGraph: ODBC.

• Treez: ODBC.

• Trello: ODBC.

• Trino: ODBC.

• TSheets: ODBC.

• Tumblr: ODBC.

• Twilio: ODBC.

• Twitter (X): ODBC.

• Twitter Ads (X Ads): ODBC.

• UPS: ODBC.

• USPS: ODBC.

• Veeva: ODBC.

• Veeva CRM: ODBC.

• Vimeo: ODBC.

• VMware Greenplum: ODBC.

• Volusion: ODBC.

• Walmart: Python.

• Wave Financials: ODBC.

• Weather: Python.

• Wistia: ODBC.

• WooCommerce: ODBC.

• WordPress: ODBC.

• Workday: ODBC.

• Wurk: ODBC.

• xBase: ODBC.

• Xero: ODBC.

• Xero WorkflowMax: ODBC.

• XML: ODBC.

• Yellowbrick: ODBC.

• Yelp: ODBC.

• YouTube: ODBC.

• YouTube Analytics: ODBC.

• Zendesk: ODBC.

• Zoho Books: ODBC.

• Zoho Creator: ODBC.

• Zoho CRM: ODBC.

• Zoho Inventory: ODBC.

• Zoho Invoice: ODBC.

• Zoho People: ODBC.

• Zoho Projects: ODBC.

• Zoom: ODBC.

• Zuora: ODBC.