Supported Data Providers and Sources

Astera Centerprise can read data from a wide range of sources. In this article, we have compiled a list of file formats, data providers, and web-applications that are supported by Astera Centerprise.

Databases and Data Warehouses

Here is the list of databases and data warehouse providers that Centerprise supports:

  • Amazon Redshift n/a
  • IBM Db2
  • MS Access
  • MySQL
  • Microsoft Dynamics CRM
  • Netezza
  • Oracle - Legacy
  • Oracle ODP .Net
  • PostgreSQL
  • Salesforce
  • SQL Server (Express and Enterprise editions)
  • SQLite
  • Sybase - Legacy
  • Teradata

In addition, Centerprise features an ODBC connector that uses the Open Database Connectivity (ODBC) interface by Microsoft to access data in database management systems using SQL as a standard.

Learn more about how to use the

  • object to read data from the above-mentioned data providers.

File Formats

File formats that are supported by Centerprise are:

  • COBOL
  • Delimited files
  • Fixed length files
  • XML/JSON
  • Excel workbooks
  • PDFs
  • Report sources
  • Text files
  • EDI formats (including X12, EDIFACT, HL7)

Cloud-Based Data Providers

  • Microsoft Dynamics CRM
  • PowerBI
  • Salesforce
  • SAP n/a
  • Tableau

File Systems and Transfer Protocols

  • AS2
  • FTP (File Transfer Protocol)
  • Email
  • HDFS (Hadoop Distributed File System) n/a
  • SCP (Secure Copy Protocol)
  • SFTP (Secure File Transfer Protocol)

Web Services

  • SOAP (Simple Object Access Protocol)
  • REST (REpresentational State Transfer)

Using the SOAP and REST web services connector, you can easily connect to any data source that uses SOAP protocol or can be exposed via REST API.

Here are some applications* that you can connect to using the REST Client object in Centerprise:

  • FinancialForce
  • Force.com Applications
  • Google Analytics
  • IBM dashDB
  • Oracle Sales Cloud
  • Oracle Service Cloud
  • Salesforce1 Lightning
  • ServiceMAX
  • SAP Sybase
  • Sugar CRM
  • Veeva CRM
  • OneDrive
  • Oracle Cloud
  • Oracle Eloqua
  • Google Cloud
  • Google Drive
  • Microsoft Azure

The list is non-exhaustive.

Read:

Support for Custom Connectors

Using Microsoft .NET APIs, you can also build a custom transformation or connector from the ground up very quickly and weave in data from various sources.