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?
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: servicedesk@paxata.com. 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
日本語
