![]() ![]() For information about configuring a MySQL driver, see How can I improve the performance of a MySQL driver?įor information about defining DataSet names (DSNs) and using Open Database Connectivity (ODBC) to access data, refer to documentation for ODBC.īy default, the ODBC connection uses the settings defined in the DSN. #UNIVERSAL DATABASE DSN FORMAT WINDOWS#(You can access the the Windows ODBC Data Source Administrator by entering "ODBC" in the Start Menu search, then selecting "Data Sources (ODBC)".) For more information about creating a DSN, refer to the Windows ODBC Help (by searching for "ODBC" in Windows Help and Support) or view the training video in above. You can create a DSN using the Windows ODBC Data Source Administrator. When uploading data from an ODBC DataSet, you must specify an existing Data Source Name (DSN). This is the description of the DataSet as it appears in Domo.Ī new ODBC DataSet Job is added to the list of jobs for the currently authenticated account. Note that after creating the job, you cannot edit any of the settings you just configured except for the DataSet name. If you want to change any of the other settings, you must create a new job.Ī panel opens with options for configuring your ODBC connection and defining your query. The DataSet type you select or enter here is reflected as the connector type in Domo after you execute the job.Įnter a description for the DataSet if desired. In the DataSet Type field, select the type of DataSet in the dropdown. This is the only setting you can change after saving the new job. This is the name of the uploaded DataSet in Domo. In the DataSet Name field, enter the name of the DataSet. In the Reader Type menu, select Database Query. In the Transport Type menu, select ODBC Connection Provider. This is the name of the job as it appears in Workbench, not the name of the uploaded DataSet in Domo. In the Name field, enter a name for the DataSet Job. If you have only one account set up, that account is already chosen for you and the menu is unavailable. Select the desired account (Domo instance) in the Domo Domain dropdown menu. To create an ODBC DataSet job in Workbench 5.1,Ĭlick the icon in the left-hand icon bar.Ĭlick the "+" button in the top right corner of the jobs listing pane. Note: Workbench 5.1 determines at runtime whether you are using a 32- or 64-bit version of Windows thus you are not asked to specify a version. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |