Data Providers and File Formats Supported in Astera
Astera 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.
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, Astera 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 are planned for the Astera 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 Astera:
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.
Last updated