Visit the official Paxata Documentation portal for all of your doc needs.

What are the data connections I can access within Paxata

Customer_QuestionCustomer_Question Posts: 9
edited November 9, 2018 10:29PM in Admin Corner
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?

Comments

  • jmayhewjmayhew Posts: 23 admin
    edited November 7, 2018 8:23PM
    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.
  • jmayhewjmayhew Posts: 23 admin
    edited November 8, 2018 2:17AM
    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.
  • 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?
  • @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
  • 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.
  • @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
Sign In or Register to comment.