Sign Up
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Introducing the new era of #ValueDrivenAI. Welcome to the DataRobot AI Platform 9.0. Find out more.

What are the data connections I can access within Paxata

Customer_Questi
Image Sensor
‎11-07-2018 10:53 PM

What are the data connections I can access within Paxata

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?
0 Kudos
Reply
6 Replies
bstephens
Linear Actuator
‎03-19-2019 03:48 PM

@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
Reply
Dhinesh
Blue LED
‎03-19-2019 10:02 AM

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
Reply
bstephens
Linear Actuator
‎03-12-2019 07:03 PM

@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
Reply
Dhinesh
Blue LED
‎03-12-2019 12:49 PM

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
Reply
jmayhew
Linear Actuator
‎11-08-2018 12:26 AM

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.

Reply
jmayhew
Linear Actuator
‎11-07-2018 10:58 PM

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
Reply