![]() Yes, you can change the data type of the columns imported into Zoho Analytics. Can I change the data type of the columns imported in Zoho Analytics? Click here to learn about the Look-up column feature. However, you can manually link the tables in Zoho Analytics using the Look-up column feature. If you import data from one table at a time (using the single table option) then the foreign keys will not be defined. The foreign keys will be created as Look-up columns in Zoho Analytics. When importing multiple tables, the foreign keys defined between the tables in Oracle database will be linked in Zoho Analytics. Will foreign keys defined between my tables in the Oracle database be linked in Zoho Analytics as well? The Local Database - Synchronization Settings will open.Ħ.Click the required Oracle database data source. All data sources for this workspace will be listed.You can schedule the import for an existing table by following the steps below. Zoho Analytics allows you to schedule the import anytime. Please note that if you access the workspace before the initial fetch, it will not display any data. 4. How can I schedule import from Oracle database? You will receive an email notification once the import is complete. This depends upon the amount of data to be imported into Zoho Analytics and also the response time of your local database. Modify the settings as needed.ģ. How long does it take for the data to be imported into Zoho Analytics?Īfter setup, you might have to wait sometime for the initial fetch to happen. ![]() Click the Oracle database data source you want to edit. All data sources for this Workspace will be listed.You can edit the import setup anytime needed by following the steps below. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |