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

How do I setup data connectors?

I need to set up connectors for Sharepoint, Hana, SFTP, Hive, and Oracle. What is the process? What information will I require? How do I go about this?

Comments

  • jmayhewjmayhew Posts: 23 admin
    edited November 8, 2018 6:29PM
    For on-premise deployments, your Paxata Administrator will provision any data connectors required. For those accessing our cloud version, you can work with your Customer Success Manager to get any data connectors provisioned. If you are not sure who that is, you can send an email to: [email protected]

    Once a data connector is provisioned, you can use it to connect to 1 or many different systems by setting up a data source configuration file. In order to configure your connector, you'll need to gather the following information:
    • What is the IP address of the server we are connecting to?
    • What is the port number that will be listening to the request?
    • Is there a instance name, server name, database name, or some other name we need?
    • Are there specific folders, schemas, directories, or buckets that we should directly access?
    • What user account & password will be used for authentication purposes?
    • Which users can access this connection? Are there security restrictions we should introduce?
    Special notes:
    • If you need to setup a data source configuration to any Hadoop File Store (ex: CDH or HDP), Hadoop Database (ex: Hive) - those will require additional setup when provisioning the data connector (typically requiring hadoop configuration files to be deployed within Paxata). For cloud deployments, Paxata Expert Services will typically work with your internal Hadoop Administrators in provisioning the data connections before configuring the data source configuration files.
    • If you need to provision a connector to a database, we there may be some additional drivers and/or additional configurations that may also be required. Please work with your CSM on those details.

      For specific requirements, you can check the following:
      File Stores Database:
      Most of the databases will only require 3 things:
      1. JDBC URL (Consult your database documentation for details of the JDBC connection URL syntax).
      2. User name
      3. Password
      Here is a list of our databases we are currently certified for. You can click on any links that appear for more specific details.
      • 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
      Non-SQL Databases
      • AWS DynamoDB
      • Cloudant
      • REST API: HTTP, GET, and, POST requests with URL only.
      Applications BI Applications:
Sign In or Register to comment.