Skip to main content

BackPrevious Topic  Next TopicNext

New Data Source Dialog Box

You can use the New Data Source dialog box to create a data source in the current catalog and select the type for the first connection in the data source. This topic describes the options in the dialog box.

Designer displays the New Data Source dialog box when you select Home/File > New > Data Source, or select a data source and select New Data Source on the Catalog Manager toolbar.

New Data Source dialog box

You see the following options in the dialog box:

Data Source Name

Specify the name of the new data source. The name should follow the Java class naming rule.

Connection Type

Select the type of the first connection to create in the new data source:

  • Oracle
    Select to create a JDBC connection to retrieve data stored in an Oracle database.
  • SQL Server
    Select to create a JDBC connection to retrieve data stored in an SQL Server database.
  • MySQL
    Select to create a JDBC connection to retrieve data stored in a MySQL database.
  • InterSystems IRIS
    Select to create a JDBC connection to retrieve data stored in an InterSystems IRIS database.
  • PostgreSQL
    Select to create a JDBC connection to retrieve data stored in a PostgreSQL database.
  • JDBC
    Select to create a JDBC connection to retrieve data stored in a relational database.
  • JSON
    Select to createa JSON connection to retrieve data stored in a JSON data source.
  • XML
    Select to create an XML connection to retrieve data stored in an XML data source.
    • Relational Data Source
      Select to retrieve data stored in an XML data source by transforming an XML hierarchy model to a relational model.
    • Hierarchical Data Source
      Select to create retrieve data stored in an XML data source by importing an XML hierarchical data source.
  • Hierarchical
    Select to create a hierarchical data source.
  • User Defined
    Select to create a user-defined data source.
  • SOAP Web Service
    Select to create a web service connection to retrieve data stored in a SOAP Web Service data source.
  • MongoDB
    Select to create a MongoDB connection to retrieve data stored in a MongoDB database.
  • Hive
    Select to create a JDBC connection to retrieve data from a relational database stored in a Hive data source.
  • Elasticsearch
    Select to create an Elasticsearch connection to retrieve data from an Elasticsearch data source.

OK

Select to apply all changes and close the dialog box.

Cancel

Select to close the dialog box without saving any changes.

Help

Select to view information about the dialog box.

BackPrevious Topic  Next TopicNext

Was this article helpful?