cancel
Showing results for 
Search instead for 
Did you mean: 

What are the data connections I can access within Paxata

Highlighted
Image Sensor
I understand that in order for me to bring data into Paxata, that a connector may need to be defined to enable Paxata with the ability to either import or export to my system. What are the connectors that Paxata currently supports? How do I get these connectors setup within my environment?
Labels (1)
0 Kudos
6 Replies
Highlighted
Linear Actuator
For 2019 and later, you can access that information within Paxata:
Image: https://us.v-cdn.net/6030933/uploads/editor/vv/68f5rihbzdds.png
From there you will see a link for Data Sources. This list is updated upon each release. 


The supported data sources for the 2018.2 SP1 release include:
Databases:
  • Azure SQL Data Warehouse
  • Hive (CDH5) - Version: CDH 5.12-5.14
  • Hive (HDP2) - Version: HDP 2.6.3
  • IBM DB2 - Version: 10.x+
  • IBM Netezza - Version: 7.x+
  • MS Azure SQL
  • MS SQL Server - Version: 2012
  • Oracle - Version: 11, 12
  • PostgreSQL - Version: 8.4
  • MySQL - Version: 5.1
  • Redshift
  • SAP HANA - Version: SPS 11
  • Snowflake
  • Teradata - Version: 15.0+
  • Vertica
File/Object Stores
  • Amazon S3
  • Azure Blob Storage (WASB)
  • Azure Data Lake Store (ADLS)
  • Google Cloud Storage
  • HDFS on CDH5 - Version: CDH 5.12-5.14
  • HDFS on HDP2 - Version: HDP 2.6.3
  • Network Share (SMB / Samba) - Version: SMB v2, v3
  • SFTP (note: SFTP servers compatible with clients that use protocol version 1,2, or 3)
  • SharePoint - Version: 2013, 2016, Online
No SQL Databases
  • AWS DynamoDB
  • Cloudant
  • REST API (HTTP, GET, and POST requests with URL only)
Applications
  • Salesforce
  • Microsoft Dynamics 365
You can also export to the following Business Intelligence applications:
  • MicroStrategy - Version: 10.9
  • Tableau - Versions: 9.3.7, 10.0.x, 10.5.x, Online
For additional details, please refer to the attached Data Source Support Matrix.
0 Kudos
Highlighted
Linear Actuator

The following sources are supported with the 2018.2 release: Database:

  • Azure SQL- Data Warehouse
  • Hive (CDH5) - Version: CDH 5.12-5.14
  • Hive (HDP2) - Version: HDP 2.6.3
  • IBM DB2 - Version: 10.x+
  • IBM Netezza - Version: 7.x+
  • MS Azure SQL
  • MS SQL Server - Version: 2012
  • MySQL - Version: 5.1
  • Oracle - Version: 11, 12
  • PostgreSQL - Version: 8.4
  • Redshift
  • SAP HANA SPS - Version: 11
  • Snowflake
  • Teradata - Version: 15.0+
  • Vertica

File Stores

  • Amazon S3
  • Azure Blob Storage (WASB)
  • Azure Data Lake Store (ADLS)
  • Google Cloud Storage
  • HDFS on CDH5 - Version: CDH 5.12-5.14
  • HDFS on HDP2 - Version: HDP 2.6.3
  • Network Share (SMB / Samba) - Version: SMB v2, v3
  • SFTP - Version: SFTP servers compatible with clients that use protocol version 1,2, or 3
  • SharePoint - Version: 2013, 2016, Online

Non-SQL Databases

  • AWS DynamoDB
  • Cloudant
  • REST API: HTTP, GET, and, POST requests with URL only.

Applications

  • Microsoft Dynamics 365
  • Salesforce - Version: API v40

Paxata also supports exports to the following BI Applications:

  • MicroStrategy - Version: 10.9
  • Tableau - Version: 9.3.7, 10.0.x, 10.5.x, Online

Additional details can be found in the Attached Data Source Support Matrix. For information on how to setup the connectors , please click here.

0 Kudos
Highlighted
Blue LED
How to connect to Linux server for a file? Also, whenever the file is updated in the Linux server, it has to be refreshed in Paxata. Is this possible?
0 Kudos
Highlighted
Linear Actuator
@Dhinesh
When connecting to a Linux server for a file we would typically need to identify the protocol needed to communicate with the server, then use the Connector associated with that protocol. While we don't support an SSH Connector, there are a couple of options, assuming that your Linux server has a routable IP/hostname from outside your network and any firewall can be edited to allow access to an open port: 
  • SFTP: Configure SFTP on your server using OpenSSH, Then use our SFTP Connector to perform secure file transfer over SSH.
  • Samba: Configure your server with a SMB network file share, then use the Network File Share (Samba) Connector for secure file transfer.
Once you have exposed a secure protocol supported by a Paxata Connector, you can leverage Paxata's Automation features to import the latest version of your datafile(s) on a schedule that you define in Paxata. In this way, your Data Preparation Project always works with the latest version of your data. 

I hope this helps,
Bill
0 Kudos
Highlighted
Blue LED
Thanks @bstephens. Have tried with SFTP option with the host name format as "sftp.10.0.0.0" (ip masked), but getting error as "Couldn't connect to the SFTP server". please let me know is there error in host name format.
0 Kudos
Highlighted
Linear Actuator
@Dhinesh
Your hostname / IP address of your server needs to be publicly routable to enable communication from our Cloud-based servers. The "10.*.*.*" address that you have provided cannot be used outside of your private network. 

IP address ranges are reserved specifically as non-routable addresses to be used in private networks:
10.0.0.0 through 10.255.255.255
172.16.0.0 through 172.32.255.255
192.168.0.0 through 192.168.255.255

I'll assume that this server is deployed on a corporate network. If so, you will need to work with your local Operations / IT to expose this SFTP server through your corporate firewall. When they do this, you should receive a routable IP address/port that allow our servers to communicate with your private server. 

Thanks,
Bill
0 Kudos
Labels