CData Virtuality

Snowflake is a fantastic database for analytical storage and for reading and writing of data. Data Virtuality's Snowflake connector supports a single connection to a single database. If you need to connect to multiple databases, it is recommended you create multiple connections, one for each database. For example, this Snowflake instance has four databases. We currently have a single connection to the test_db database./* Create connection */call SYSADMIN.createConnection(name => 'snowflake_dv', jbossCliTemplateName => 'snowflake', connectionOrResourceAdapterProperties => 'host=************************.snowflakecomputing.com,db=test_db,user-name=qa,check-valid-connection-sql="select 0",warehouse=DEMO_WH'

In scenarios, where Active Directory authentication is activated, there is no out-of-the-box DV connect role available. Additionally, we would like a developer to have access to all things they create, without an admin having to grant them permissions. In a development/test/(acceptance/)production CI/CD scenario, a different role/person will be in charge to implement the changes on a 'higher' instance.In our example we will first allow the developer role everything, but reduce the permissions later on.In detail, we prevent the developers from creating/adding/removing data sources and users. We also prevent them from setting permissions for themselves.The developer-role must exist (coming from AD/LDAP) and be assigned to developers.EXEC SYSADMIN.setPermissions("role_name" => 'developer-role', "resourceName" => '*', "permissions" => 'CRUDEAL', "condition" => NULL, "isConstraint" => true, "mask" => NULL, "maskOrder" => NULL) ;EXEC SYSA

In addition to the built-in Certified Data Virtuality LDW Power BI Connector - included with Power BI Desktop and the on-premises data gateway - enhanced integration is supported through the CData Virtuality Custom Connector.This custom connector supports PBIDS files provided through the CData Virtuality Datashop, enabling seamless connectivity between CData Virtuality and Power BI. To use this functionality, the connector must be installed separately.This article describes the installation of the CData Virtuality Custom Connector.PrerequisitesInstall the CData Virtuality ODBC driver. The installer for the ODBC driver can be downloaded from here. Install the current version of Power BI Desktop.Installation of the CData Virtuality Custom ConnectorDownload the Custom Connector. 

Some databases require connections to multiple ports simultaneously. DB2 is a good example of this as you can see in the table below. Function Port (non-TLS) TLS Port Server Mapper 449 449 License Management 8470 9470 RPC/DPC 8475 9475 Sign-On Verification 8476 9476 Database Access 8471 9471 The above table has been reproduced from the IBM documentation for explanatory purposes. The complete documentation can be found here:Ports That Must Be Open to Make an ODBC, Data Transfer, OLE DB, ADO.Net, or JDBC Connection through a Firewallhttps://www.ibm.com/s

Hey everyone! We are thrilled to announce the launch of CData Virtuality 4.6! Just eight weeks after acquiring Data Virtuality, we’ve reached a significant milestone that showcases our commitment to leading the data integration market. Here are the highlights: Seamless Integration of CData Connectors Under the expert leadership of Dr. Nick Golovin, our team has developed a framework that allows easy integration of any CData Driver into CData Virtuality. This advancement simplifies the addition of new connectors, enabling seamless integration of over 300 CData connectors within just a few days. 18 New Connectors Added in Record Time We’ve already integrated the first 18 CData Connectors into CData Virtuality 4.6, including: • Amazon DynamoDB• Azure Analysis Services• CData Connect Cloud• CosmosDB• ElasticSearc

Thank you to everyone who joined our recent webinar featuring Kevin Petrie and Nick Golovin on "Five Styles of Data Integration." We gathered some insightful questions from the audience and have provided detailed answers below. We hope these will help you better understand the different data integration techniques and how they can be applied in various scenarios. Question 1: Competitive Advantage of Reverse ETLQuestion: Can you please tell me if Reverse ETL has any competitive advantage over the other techniques? Especially regarding removing silos?Answer: Reverse ETL, where data is moved from a data warehouse back into an application, complements rather than competes with other data integration techniques. It's not typically used to remove silos but to enhance application data with insights generated from the data warehouse. Question 2: Managing Dual Virtualization

 We’re excited to announce the acquisition of Data Virtuality, a leading enterprise data virtualization provider. Below is a brief FAQ designed to provide answers to a few common questions regarding this news.   If you have additional questions not covered in this FAQ, please contact us at [email protected] and a member of our team will assist you.   What is CData Software? CData Software is a leading provider of data access and connectivity. Our standards-based solutions streamline data access and insulate customers from the complexities of integration across ETL/ELT, data virtualization, B2B data integration and embedded connectivity. Leading applications across SaaS, data management, integration, analytics & BI, data science, AI & machine learning, a