Data Providers and File Formats Supported in Centerprise

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

Databases and Data Warehouses

  • Amazon Aurora
  • MySQL
  • Amazon Aurora Postgres
  • Amazon RDS
  • Amazon Redshift
  • DB2
  • Google Cloud SQL
  • MariaDB
  • Microsoft Azure
  • Microsoft Dynamics CRM
  • MS Access
  • MySQL
  • Netezza
  • Oracle
  • PostgreSQL
  • PowerBI
  • Salesforce (Legacy)
  • Salesforce Rest
  • SAP Hana
  • Snowflake
  • SQL Server
  • Sybase
  • Tableau
  • Teradata
  • Vertica

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.

To learn more about how to use the object to read data from the above-mentioned data providers, click here.

File Formats

  • 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
  • Tableau
  • Amazon S3 Bucket Storage
  • Microsoft Azure Blob Storage

Note: Amazon S3 Bucket Storage and Microsoft Azure Blob Storage is planned for Astera Centerprise 9.1 release.

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
  • Google Cloud
  • Google Drive
  • Hubspot
  • IBM DB2 Warehouse
  • Microsoft Azure
  • OneDrive
  • Oracle Cloud
  • Oracle Eloqua
  • Oracle Sales Cloud
  • Oracle Service Cloud
  • Salesforce Lightning
  • ServiceMAX
  • SugarCRM
  • Veeva CRM

The list is non-exhaustive.

Read: How to connect to Eloqua using REST client object

Support for Custom Connectors

You can also build a custom transformation or connector from the ground up quickly and easily using the Microsoft .NET APIs, and retrieve data from various other sources.