Posted by: aparna.singh - 07-15-2019, 08:11 AM - Forum: FAQs
- No Replies
Q. Does BDB Platform has the ability to export results of data preparation into various formats, directly into databases, excel files, Tableau data models, Tableau server data model, etc.?
(07-15-2019, 08:11 AM)aparna.singh Wrote: Q. Does BDB Platform has the ability to export results of data preparation into various formats, directly into databases, excel files, Tableau data models, Tableau server data model, etc.?
A. Yes, BDB's Data preparation/ETL module empowers the user to export results of data preparation into various formats, including directly into databases & excel files. Once the data is available into databases & excel files it can be used further in Tableau server.
Q. Is BDB Platform capable of performing various operations on the data filtering, joining, union, merge, append, transform, cross-tab, parse, clean (e.g. regexp), profile, date functions, etc.?
A. Yes, using BDB Data prep/ETL users can easily perform various operations like filtering, joining, union, merge, append, etc. with easy drag and drop interface.
The platform has 60+ transformations which keep on increasing. It can be done through both ETL and Data Preparation.
Q. Can we combine and join data from different sources without coding?
(07-08-2019, 12:44 PM)aparna.singh Wrote: Q. Can we combine and join data from different sources without coding?
A. Yes, BDB ETL empowers data-driven business users with powerful capabilities to extract, transform, and load unified data to the destination. With BDB ETL business Users will be able to combine and join data from different sources without coding, with easy drag and drop based service.
Refer attached image to know how data can be joined from multiple Sources.
Q. Does Platform has the ability to connect to different data sources, including, but not limited to databases (MS SQL, Oracle, MongoDB, cloud-sources, flat files, web- data sources, SharePoint, lists, excel, files, XML-files, JSON, ZIP-files, etc.)?
(07-08-2019, 12:15 PM)aparna.singh Wrote: Q. Does Platform has the ability to connect to different data sources, including, but not limited to databases (MS SQL, Oracle, MongoDB, cloud-sources, flat files, web- data sources, SharePoint, lists, excel, files, XML-files, JSON, ZIP-files, etc.)?
BDB Platform has Built-in data connectors to fetch data from different data sources. It supports MySQL, Oracle, Hive, MongoDB, Flat files, Cassandra, SAP HANA, Google sheet, Facebook, Twitter, etc. BDB Platform also has the capability to develop custom connectors based on the business requirements