Delphix Products

I am trying to mask a Cassandra Database. Currently I have masked Oracle, SQL databases using Delphix. Please let me know if I can mask Cassandra database using delphix. If yes, what is the difference in steps from the usual Oracle or SQL databases

Hi Dimple,

My notes say that it is possible, but it requires a Custom Connector and Professional Services are required for support.  You should talk with your Delphix account partners (Sales Engineer, CSM, RSM, etc). 

In general, there's two options:

• Buy 3rd party driver to make Cassandra look like a Relational database.  See CData: Cassandra
• Unload the data to delimited files, mask, reload

If this is a large Cassandra database, talk to your CSM to see if Cassandra is on the roadmap for Delphix Hyperscale Compliance

When you do have success, please come back and post your experience!  It will be valuable for customers in the future (like myself) :-)

I am trying to mask a Cassandra Database. Currently I have masked Oracle, SQL databases using Delphix. Please let me know if I can mask Cassandra database using delphix. If yes, what is the difference in steps from the usual Oracle or SQL databases

There is Delphix support available for us, but I am not aware of what level of support they can provide. But before checking with them I wanted to know about the custom connector. Will the Delphix team be able to provide a connector which can connect to Cassandra DB and then I can mask it similar to other DBs?

Hi Dimple,

My notes say that it is possible, but it requires a Custom Connector and Professional Services are required for support.  You should talk with your Delphix account partners (Sales Engineer, CSM, RSM, etc). 

In general, there's two options:

• Buy 3rd party driver to make Cassandra look like a Relational database.  See CData: Cassandra
• Unload the data to delimited files, mask, reload

If this is a large Cassandra database, talk to your CSM to see if Cassandra is on the roadmap for Delphix Hyperscale Compliance

When you do have success, please come back and post your experience!  It will be valuable for customers in the future (like myself) :-)

I am trying to mask a Cassandra Database. Currently I have masked Oracle, SQL databases using Delphix. Please let me know if I can mask Cassandra database using delphix. If yes, what is the difference in steps from the usual Oracle or SQL databases

I am trying to mask a Cassandra Database. Currently I have masked Oracle, SQL databases using Delphix. Please let me know if I can mask Cassandra database using delphix. If yes, what is the difference in steps from the usual Oracle or SQL databases

We have heard about accessing Cassandra using Hive or Spark .. but that might be restricted to queries (not update/inserts). Further there are some commercial JDBC vendors like CData that offer custom drivers that translate between SQL and the targeted DB native protocol .. but those drivers may have functional restrictions means I would first get a test version to verify functionality.

My suggestion is to use the ExtractMaskLoad approach, in CQL language (CassandraQueyLanguage) you can use COPY command to export to CSV/import from CSV > and mask the extracted CSV files in Delphix using the Delimited connector. This approach possibly offers the best performance and no costs.

I am trying to mask a Cassandra Database. Currently I have masked Oracle, SQL databases using Delphix. Please let me know if I can mask Cassandra database using delphix. If yes, what is the difference in steps from the usual Oracle or SQL databases

Thanks for the suggestion.

So if I proceesd with the ExtractMaskLoad approach, the masking using delimited connector would be different from other usual masking approach?

We have heard about accessing Cassandra using Hive or Spark .. but that might be restricted to queries (not update/inserts). Further there are some commercial JDBC vendors like CData that offer custom drivers that translate between SQL and the targeted DB native protocol .. but those drivers may have functional restrictions means I would first get a test version to verify functionality.

My suggestion is to use the ExtractMaskLoad approach, in CQL language (CassandraQueyLanguage) you can use COPY command to export to CSV/import from CSV > and mask the extracted CSV files in Delphix using the Delimited connector. This approach possibly offers the best performance and no costs.

I am trying to mask a Cassandra Database. Currently I have masked Oracle, SQL databases using Delphix. Please let me know if I can mask Cassandra database using delphix. If yes, what is the difference in steps from the usual Oracle or SQL databases

We have heard about accessing Cassandra using Hive or Spark .. but that might be restricted to queries (not update/inserts). Further there are some commercial JDBC vendors like CData that offer custom drivers that translate between SQL and the targeted DB native protocol .. but those drivers may have functional restrictions means I would first get a test version to verify functionality.

My suggestion is to use the ExtractMaskLoad approach, in CQL language (CassandraQueyLanguage) you can use COPY command to export to CSV/import from CSV > and mask the extracted CSV files in Delphix using the Delimited connector. This approach possibly offers the best performance and no costs.

I am trying to mask a Cassandra Database. Currently I have masked Oracle, SQL databases using Delphix. Please let me know if I can mask Cassandra database using delphix. If yes, what is the difference in steps from the usual Oracle or SQL databases

Is this the right documentation where it is showing to mask a file - Masking Whole File - Delphix Masking Documentation

We have heard about accessing Cassandra using Hive or Spark .. but that might be restricted to queries (not update/inserts). Further there are some commercial JDBC vendors like CData that offer custom drivers that translate between SQL and the targeted DB native protocol .. but those drivers may have functional restrictions means I would first get a test version to verify functionality.

My suggestion is to use the ExtractMaskLoad approach, in CQL language (CassandraQueyLanguage) you can use COPY command to export to CSV/import from CSV > and mask the extracted CSV files in Delphix using the Delimited connector. This approach possibly offers the best performance and no costs.

I am trying to mask a Cassandra Database. Currently I have masked Oracle, SQL databases using Delphix. Please let me know if I can mask Cassandra database using delphix. If yes, what is the difference in steps from the usual Oracle or SQL databases

You don't need that for masking delimited files.  That is an edge case where you need to pass the entire file into an algorithm.  This was needed to mask JSON before JSON support was added.  

Is this the right documentation where it is showing to mask a file - Masking Whole File - Delphix Masking Documentation

We have heard about accessing Cassandra using Hive or Spark .. but that might be restricted to queries (not update/inserts). Further there are some commercial JDBC vendors like CData that offer custom drivers that translate between SQL and the targeted DB native protocol .. but those drivers may have functional restrictions means I would first get a test version to verify functionality.

My suggestion is to use the ExtractMaskLoad approach, in CQL language (CassandraQueyLanguage) you can use COPY command to export to CSV/import from CSV > and mask the extracted CSV files in Delphix using the Delimited connector. This approach possibly offers the best performance and no costs.

I am trying to mask a Cassandra Database. Currently I have masked Oracle, SQL databases using Delphix. Please let me know if I can mask Cassandra database using delphix. If yes, what is the difference in steps from the usual Oracle or SQL databases

Thanks for the response. So when masking cassandra as delimited files is it possible for In-place masking or on the fly would be the best option? 

You don't need that for masking delimited files.  That is an edge case where you need to pass the entire file into an algorithm.  This was needed to mask JSON before JSON support was added.  

Is this the right documentation where it is showing to mask a file - Masking Whole File - Delphix Masking Documentation

We have heard about accessing Cassandra using Hive or Spark .. but that might be restricted to queries (not update/inserts). Further there are some commercial JDBC vendors like CData that offer custom drivers that translate between SQL and the targeted DB native protocol .. but those drivers may have functional restrictions means I would first get a test version to verify functionality.

My suggestion is to use the ExtractMaskLoad approach, in CQL language (CassandraQueyLanguage) you can use COPY command to export to CSV/import from CSV > and mask the extracted CSV files in Delphix using the Delimited connector. This approach possibly offers the best performance and no costs.

I am trying to mask a Cassandra Database. Currently I have masked Oracle, SQL databases using Delphix. Please let me know if I can mask Cassandra database using delphix. If yes, what is the difference in steps from the usual Oracle or SQL databases

You can do either :)  I would choose OTF because if anything goes wrong with the masking you can easily apply changes and re-run the job.

Thanks for the response. So when masking cassandra as delimited files is it possible for In-place masking or on the fly would be the best option? 

You don't need that for masking delimited files.  That is an edge case where you need to pass the entire file into an algorithm.  This was needed to mask JSON before JSON support was added.  

Is this the right documentation where it is showing to mask a file - Masking Whole File - Delphix Masking Documentation

We have heard about accessing Cassandra using Hive or Spark .. but that might be restricted to queries (not update/inserts). Further there are some commercial JDBC vendors like CData that offer custom drivers that translate between SQL and the targeted DB native protocol .. but those drivers may have functional restrictions means I would first get a test version to verify functionality.

My suggestion is to use the ExtractMaskLoad approach, in CQL language (CassandraQueyLanguage) you can use COPY command to export to CSV/import from CSV > and mask the extracted CSV files in Delphix using the Delimited connector. This approach possibly offers the best performance and no costs.

I am trying to mask a Cassandra Database. Currently I have masked Oracle, SQL databases using Delphix. Please let me know if I can mask Cassandra database using delphix. If yes, what is the difference in steps from the usual Oracle or SQL databases

Is it possible to share a delphix document link explaining this on the fly masking using the delimited connector - from creating connector to masking as I need to refer and define a process which can be suitable for our customer.

You can do either :)  I would choose OTF because if anything goes wrong with the masking you can easily apply changes and re-run the job.

Thanks for the response. So when masking cassandra as delimited files is it possible for In-place masking or on the fly would be the best option? 

You don't need that for masking delimited files.  That is an edge case where you need to pass the entire file into an algorithm.  This was needed to mask JSON before JSON support was added.  

Is this the right documentation where it is showing to mask a file - Masking Whole File - Delphix Masking Documentation

We have heard about accessing Cassandra using Hive or Spark .. but that might be restricted to queries (not update/inserts). Further there are some commercial JDBC vendors like CData that offer custom drivers that translate between SQL and the targeted DB native protocol .. but those drivers may have functional restrictions means I would first get a test version to verify functionality.

My suggestion is to use the ExtractMaskLoad approach, in CQL language (CassandraQueyLanguage) you can use COPY command to export to CSV/import from CSV > and mask the extracted CSV files in Delphix using the Delimited connector. This approach possibly offers the best performance and no costs.

I am trying to mask a Cassandra Database. Currently I have masked Oracle, SQL databases using Delphix. Please let me know if I can mask Cassandra database using delphix. If yes, what is the difference in steps from the usual Oracle or SQL databases

This is basic knowledge, have you had any kind of training ?

For OTF you need two environments, one to read from and one to write to.

In each environment a delimited connector connecting to the files using either ftp/sftp/nfs/cifs/blockStorage.

On the TARGET environment you create a ruleset, add to ruleset the files either by selecting them or using a regex pattern to match the files.
On the ruleset per FILE or PATTERN you assign the file-format.

The file-format for delimited is very simple, just one horizontal line per COLUMN of the data, this is used to render the UI where you enter the domain/algorithms. Column names must not contain space or special characters!

Assign algorithms in ruleset as required and run masking job. Done.

Is it possible to share a delphix document link explaining this on the fly masking using the delimited connector - from creating connector to masking as I need to refer and define a process which can be suitable for our customer.

You can do either :)  I would choose OTF because if anything goes wrong with the masking you can easily apply changes and re-run the job.

Thanks for the response. So when masking cassandra as delimited files is it possible for In-place masking or on the fly would be the best option? 

You don't need that for masking delimited files.  That is an edge case where you need to pass the entire file into an algorithm.  This was needed to mask JSON before JSON support was added.  

Is this the right documentation where it is showing to mask a file - Masking Whole File - Delphix Masking Documentation

We have heard about accessing Cassandra using Hive or Spark .. but that might be restricted to queries (not update/inserts). Further there are some commercial JDBC vendors like CData that offer custom drivers that translate between SQL and the targeted DB native protocol .. but those drivers may have functional restrictions means I would first get a test version to verify functionality.

My suggestion is to use the ExtractMaskLoad approach, in CQL language (CassandraQueyLanguage) you can use COPY command to export to CSV/import from CSV > and mask the extracted CSV files in Delphix using the Delimited connector. This approach possibly offers the best performance and no costs.

I am trying to mask a Cassandra Database. Currently I have masked Oracle, SQL databases using Delphix. Please let me know if I can mask Cassandra database using delphix. If yes, what is the difference in steps from the usual Oracle or SQL databases