skip to main content
Using DataDirect Hybrid Data Pipeline : Creating a Data Source definition

Try Now

Creating a Data Source definition

You define the information that Progress DataDirect Hybrid Data Pipeline needs to connect to the data store in a Data Source definition.
The steps in this topic apply generally but the available options differ by data store type. When you are logged in to your Hybrid Data Pipeline account, follow these steps to create a Data Source definition:
1. If the Data Sources view is not already open, in the left navigation panel, click Data Sources to open it.
The Data Stores page opens.
3. From the list of Data Stores, click the logo for the type of data store to which you want to connect.
The Create Data Source page opens.
4. On the General tab, enter a data source name, and fill the required fields. If applicable, enter the login credentials for the data store. If you do not enter the login credentials at this point, a dialog will prompt you to do so, when you try to connect to the data store.
To persist the login credentials for the data store, you must enter the credentials in the data source definition page.
5. Then, do one of the following:
*Click SAVE to create the definition without testing the connection.
*Click TEST CONNECTION to establish a connection with the Data Store, create and save the data source definition. Then, click SAVE.
If you click TEST CONNECTION without specifying the login credentials, a pop-up dialog appears. Enter the login credentials for the data source and click OK.
The new Data Source is added to the list on the Data Sources page.
If you create an OData-enabled data source, the icon beside it indicates the status of the schema map generation. The following table provides details of the icons:
Schema Synch in progress
The synchronization of the schema map is in progress. The number denotes the percentage of synchronization completed.
Synch completed successfully
The schema map was synchronized successfully.
Errors when synching a schema map
Errors occurred while synchronizing the schema map. You must synchronize the schema map again.
Schema map resynch needed
You must synchronize the schema map again.
* Parameters for all supported Data Source types
* Amazon Redshift Parameters
* Apache Hadoop Hive On-Premise Parameters
* DB2 parameters
* Google Analytics parameters
* Greenplum parameters
* Informix parameters
* Microsoft Dynamics CRM parameterss
* Microsoft SQL Server parameters
* MySQL Enterprise parameters
* MySQL Community Edition parameters
* Oracle parameters
* Oracle Marketing Cloud (Eloqua) parameters
* Oracle Sales Cloud parameters
* Oracle Service Cloud parameterss
* PostgreSQL parameters
* Progress OpenEdge parameters
* Progress Rollbase parameters
* Salesforce (and Related Data Store) connection parameterss
* SugarCRM parameters
* Sybase parameters